mysql 不能插入中文字符 中文字符读写乱码问题
环境 ： mysql-5.1.43-win32.msi + myeclipse8.0 + apache-tomcat-6.0.24.exe + jdk-6u18-windows-i586se版.exe

关键代码

mysql配置文件 my.ini 设置其字符集为gbk (重启有效)

[code="ini配置文件"]#
[client]

port=3306

[mysql]

default-character-set=gbk




# SERVER SECTION
# ----------------------------------
#
# The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it reads this
# file.
#
[mysqld]

# The TCP/IP Port the MySQL Server will listen on
port=3306


#Path to installation directory. All paths are usually resolved relative to this.
basedir="D:/Program Files/MySQL/MySQL Server 5.1/"

#Path to the database root
datadir="D:/Program Files/MySQL/MySQL Server 5.1/Application Data/Data/"

# The default character set that will be used when a new schema or table is
# created and no character set is defined
default-character-set=gbk



# The default storage engine that will be used when create new tables when
default-storage-engine=INNODB
Servlet中从页面读取字符串的处理

[code="java"]public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String username = request.getParameter("username");
try{
username = new String(username.getBytes("ISO-8859-1"));


UserDao userDao = new UserDaoImpl(new DBMGJbdc());
ArrayList userList = userDao.getUserListByUsername(username);
request.setAttribute("userList", userList);
ServletContext servletContext = this.getServletContext();
servletContext.getRequestDispatcher("/queryResult.jsp").forward(request, response);
}catch(Exception ex){
ex.printStackTrace();
}

}
JSP页面中设置页面字符集为GBK

[code="html"]

数据库使用Mysql Workbench设计,字符集均使用默认字符集