为什么server端的 character一般都设置成 latin1呀,而不是 utf8呢?
-------------------------------------------
比如,我申请的虚拟主机,就是这样.mysql> status;
--------------
mysql Ver 14.14 Distrib 5.5.9, for Win32 (x86)Connection id: 2913502
Current database: user1
Current user: [email protected]
SSL: Not in use
Using delimiter: ;
Server version: 5.1.29-rc-community MySQL Community Server (GPL)
Protocol version: 10
Connection: 78.78.78.78 via TCP/IP
Server characterset: latin1
Db characterset: latin1
Client characterset: gbk
Conn. characterset: gbk
TCP port: 3306
Uptime: 6 days 5 hours 31 min 17 secThreads: 3 Questions: 407213745 Slow queries: 14 Opens: 1648752 Flush tables
: 1 Open tables: 256 Queries per second avg: 756.513
--------------通过以下可见,sever端的字符集就是 latin1,
另外,安装mysql时,默认字符集也是 latin1而不是utf8,这是为什么呢?Server characterset: latin1
Db characterset: latin1
Client characterset: gbk
Conn. characterset: gbk
-------------------------------------------
比如,我申请的虚拟主机,就是这样.mysql> status;
--------------
mysql Ver 14.14 Distrib 5.5.9, for Win32 (x86)Connection id: 2913502
Current database: user1
Current user: [email protected]
SSL: Not in use
Using delimiter: ;
Server version: 5.1.29-rc-community MySQL Community Server (GPL)
Protocol version: 10
Connection: 78.78.78.78 via TCP/IP
Server characterset: latin1
Db characterset: latin1
Client characterset: gbk
Conn. characterset: gbk
TCP port: 3306
Uptime: 6 days 5 hours 31 min 17 secThreads: 3 Questions: 407213745 Slow queries: 14 Opens: 1648752 Flush tables
: 1 Open tables: 256 Queries per second avg: 756.513
--------------通过以下可见,sever端的字符集就是 latin1,
另外,安装mysql时,默认字符集也是 latin1而不是utf8,这是为什么呢?Server characterset: latin1
Db characterset: latin1
Client characterset: gbk
Conn. characterset: gbk
MySQL 中文显示乱码
也就是说,latin1有一定的好处,可是好处是什么呢?
设为latin1,只是为了早期版本兼容,增加容错。早期版本的编码都是latin1, latin1编码可以认为无字符格式的编码,什么字符都可以存,乱玛也可以存,至于里面是什么内容,只能靠客户端的程序来解释,在latin1编码中,比较和排序都有问题。