我的mysql是mysql-4.1.14-win32的,进入后show variables like "%char%"显示结果为
+--------------------------+--------------------------------------------------
-----+
| Variable_name | Value
|
+--------------------------+--------------------------------------------------
-----+
| character_set_client | lain1
|
| character_set_connection | lain1
|
| character_set_database | utf8
|
| character_set_results | lain1
|
| character_set_server | utf8
|
| character_set_system | utf8
|
| character_sets_dir | C:\Program Files\MySQL\MySQL Server 4.1\share\cha
ets/ |
+--------------------------+--------------------------------------------------
-----+
7 rows in set (0.00 sec)show variables like "%colla%";+----------------------+-----------------+
| 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时字符就选了utf8了
我在my.ini里面已经设了default charset了啊,怎么不能跟别人说的那样所有都显示utf8,还有就是如果我用set names utf8改了之后,退出mysql再进去又变成lain1了,要怎么做才能固定这样子,后面我又重装了,在选字符集时第二个utf8和第三个也选utf8,两次重装都选了,还有my.ini里面也是utf8的,怎么show的时候就只有三个是utf8啊,郁闷啊,望高手指点迷津啊,顺便说一下我装的是XP操作系统
+--------------------------+--------------------------------------------------
-----+
| Variable_name | Value
|
+--------------------------+--------------------------------------------------
-----+
| character_set_client | lain1
|
| character_set_connection | lain1
|
| character_set_database | utf8
|
| character_set_results | lain1
|
| character_set_server | utf8
|
| character_set_system | utf8
|
| character_sets_dir | C:\Program Files\MySQL\MySQL Server 4.1\share\cha
ets/ |
+--------------------------+--------------------------------------------------
-----+
7 rows in set (0.00 sec)show variables like "%colla%";+----------------------+-----------------+
| 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时字符就选了utf8了
我在my.ini里面已经设了default charset了啊,怎么不能跟别人说的那样所有都显示utf8,还有就是如果我用set names utf8改了之后,退出mysql再进去又变成lain1了,要怎么做才能固定这样子,后面我又重装了,在选字符集时第二个utf8和第三个也选utf8,两次重装都选了,还有my.ini里面也是utf8的,怎么show的时候就只有三个是utf8啊,郁闷啊,望高手指点迷津啊,顺便说一下我装的是XP操作系统
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货