MySQL的Collate校对问题--字段值区分大小写（国外英文资料）.doc

MySQL的Collate校对问题--字段值区分大小写（国外英文资料） Mysqls default field value is case-insensitive. If you want to make MySQL case-sensitive, instance level, [mysqld] is added in my.ini [mysqld] Default - character - set = GBK The default collation = gbk_bin. - This is case-sensitive, and Chinese characters can still be sorted by Chinese pinyin The details are as follows: Charset can be set under my.ini It should not be performed during the installation of the service phase Mysqd-nt -- install -- is the installation to the service right? I havent touched the Windows 32 platform mysql for a long time 2005-12-21, 10:49 PM Charset can be set under my.ini It should not be performed during the installation of the service phase Mysqd-nt -- install -- is the installation to the service right? I havent touched the Windows 32 platform mysql for a long time Thanks, it is. Eek: thats about -- Change the preset language to utf8, so do I have to convert all the data on the database (Big5) to utf8? ... Do you have to think about it, or does it translate itself? Eek: in the following way. (1) in the [mysqld] section Default - character - set = utf8 (2) in the [client] section Default - character - set = utf8 This is the way I used to be in mysql 3.23, I dont know how to set it in version 4.1.16. ethanliu 2005-12-23, 04:31 AM Yes, you need to convert first Its not too different, my habit is [mysqld] Init_connect = SET NAMES utf8 Default - character - set = utf8 The default collation = utf8_general_ci. - 2005-12-23, 10:50 AM Good question: How does init_connect = SET NAMES utf8 - make sense? Confused: Does the [client] block in my.ini have the same Settings? Confused: As you said, I changed my my.ini Settings, but when I executed the following two queries, I found that some of the big5 characters were still in place. Do you need to change all the way to utf8? .. (if so, how to set it in my.ini?) Confused: Mysql SHOW VARIABLES LIKE character_set_ % Character_set_client | big5