MySQL 将默认编码改为gb2312的几个步骤

（转载测试）

 1.数据库连接时要用GB2312编码连接  DBDriver = "org.gjt.mm.mysql.Driver"; ConnStr = "jdbc:mysql://localhost:3306/vote?useUnicode=true&characterEncoding=GB2312&user=root&password=tjwyNIC";  2.数据库建库要用GB2312建库，修改2个参数  CREATE DATABASE vote CHARACTER SET 'gb2312' COLLATE 'gb2312_chinese_ci';  3.建表要用GB2312建表  create table vote( voteid int(11) NOT NULL auto_increment primary key, votetitle varchar(50) NOT NULL default '', voteflag tinyint(4) NOT NULL default '1', UNIQUE KEY vid(voteid), UNIQUE KEY title(votetitle) )TYPE=MyISAM DEFAULT CHARSET=gb2312 DEFAULT COLLATE=gb2312_chinese_ci;  4.%Windows%/my.ini文件的配置  [mysqld] default-character-set=gb2312 （特别注意要加入这句改变默认编码方式） basedir=D:/mysql/mysql #bind-address=211.68.222.6 datadir=D:/mysql/mysql/data #language=D:/mysql/mysqlshare/your language directory #slow query log#= #tmpdir#= port=3306 #set-variable=key_buffer=16M [WinMySQLadmin] Server=D:/mysql/mysql/bin/mysqld-nt.exe user=zhao password=jiang QueryInterval=10  5.页面编码也要都是GB2312  page contentType="text/html; charset=gb2312"  6.表单等参数取得要改GB2312  String opname=new String(request.getParameter("op"+i).getBytes("8859_1"),"gb2312");