转载本站文章请注明，转载自: 月影鹏鹏 [http://Jacky.Aiwaly.com]
本文链接: http://jk.aiwaly.com/wp/%e7%bb%88%e4%ba%8e%e6%90%9e%e5%ae%9amysql%e7%9a%84%e5%ad%97%e7%ac%a6%e9%9b%86%ef%bc%8c%e8%ae%be%e5%ae%9a%e6%89%80%e6%9c%89%e5%8f%82%e6%95%b0%e4%b8%ba-utf8-2.html
在安装完成以后已经设置mysql设置为utf8
但是
mysql> 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> 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:\data\MySQL\MySQL Server 4.1\share\charsets/ |
+————————–+————————————————+
7 rows in set (0.00 sec)
发觉画线标注的属性还是非 utf8的。
然后修改 my.ini 文件，设置
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
default-character-set=utf8
copy my.ini 文件到 windows目录
启动mysql
+————————–+————————————————+
| 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:\data\MySQL\MySQL Server 4.1\share\charsets/ |
+————————–+————————————————+
7 rows in set (0.00 sec)
mysql> 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:\data\MySQL\MySQL Server 4.1\share\charsets/ |
+————————–+————————————————+
7 rows in set (0.00 sec)
一切正常了。
创建数据库：
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,
primary key (USERID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
