以下的文章主要向大家讲述的是MySQL数据库中的字符集设定的所有参数为UTF8的实际操作过程，我们大家都知道在安装完成之后已经对MySQL数据库设置为utf8，但是有时会出现以下的内容，如：
MySQL(和PHP搭配之最佳组合)> SHOW VARIABLES LIKE 'collation_%'; +----------------------+-------------------+ | Variable_name | Value | +----------------------+-------------------+ | collation_connection | latin1_swedish_ci | | collation_database | utf8_general_ci | | collation_server | utf8_general_ci | +----------------------+-------------------+ 3 rows in set (0.00 sec)
MySQL(和PHP搭配之最佳组合)> SHOW VARIABLES LIKE 'character_set_%';
+--------------------------+------------------------------------------------+ | Variable_name | Value | +--------------------------+------------------------------------------------+ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | utf8 | | character_set_results | latin1 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | D:dataMySQL(和PHP搭配之最佳组合)MySQL(和PHP搭配之最佳组合) Server 4.1sharecharsets/ | +--------------------------+------------------------------------------------+ 7 rows in set (0.00 sec)
发觉画线标注的属性还是非 utf8的。
然后修改 my.ini 文件，设置
以下是代码片段：
[client] default-character-set=utf8 [MySQL(和PHP搭配之最佳组合)] default-character-set=utf8 [MySQL(和PHP搭配之最佳组合)d] default-character-set=utf8
copy my.ini 文件到 windows目录
启动MySQL数据库 以下是代码片段：
MySQL(和PHP搭配之最佳组合)> SHOW VARIABLES LIKE ’character_set_%’; +--------------------------+------------------------------------------------+ | Variable_name | Value | +--------------------------+------------------------------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | D:dataMySQL(和PHP搭配之最佳组合)MySQL(和PHP搭配之最佳组合) Server 4.1sharecharsets/ | +--------------------------+------------------------------------------------+ 7 rows in set (0.00 sec) MySQL(和PHP搭配之最佳组合)> SHOW VARIABLES LIKE ’character_set_%’; +--------------------------+------------------------------------------------+ | Variable_name | Value | +--------------------------+------------------------------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | D:dataMySQL(和PHP搭配之最佳组合)MySQL(和PHP搭配之最佳组合) Server 4.1sharecharsets/ | +--------------------------+------------------------------------------------+ 7 rows in set (0.00 sec)
一切正常了。
创建数据库：
以下是代码片段：
create table t_sysuser ( USERID integer not null auto_increment, USERNAME varchar(30), PASSWORDS varchar(30), DEPTNO varchar(30), HEADSHIP varchar(30), SEX varchar(4), TEL varchar(18), EMAIL varchar(30), URL varchar(30), PCALL varchar(20), USERPHOTO varchar(255), FACEREFUTIME integer, FACELANGUAGE varchar(1), LASTMODIF varchar(30), LASTMDATE datetime, CREADTOR varchar(30), CREATDATE datetime, Prima(最完善的虚拟主机管理系统)ry key (USERID) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
全部搞定。
上面说了这么多内容，是关于对MySQL数据库的字符集设定所有参数为UTF8的介绍，不知道各位对MySQL的认识是不是更上一层楼了，时时关注ITJS，学习最新Mysql技术。