搞掂MySQL中文支持问题,终极大法,散分啦
哈哈
爽啊
搞掂了中文支持问题
back_log 50
basedir C:\mysql\
bdb_cache_size 8388600
bdb_log_buffer_size 32768
bdb_home C:\mysql\data\
bdb_max_lock 10000
bdb_logdir
bdb_shared_data OFF
bdb_tmpdir C:\WINNT\TEMP\
bdb_version Sleepycat Software: Berkeley DB 3.2.9a: (February 14, 2002)
binlog_cache_size 32768
character_set gbk
character_sets latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5
concurrent_insert ON
connect_timeout 5
datadir C:\mysql\data\
......
现在无论select还是group by都可以按照汉语拼音排序,爽啊!
不用在PHP里面构造字符库啦,散分了!!!
只要在my.ini里面加上
[mysqld]
......
default-character-set=gbk
重启mysql就好了
就这么简单,可是www.mysql.com的文档却瞎说,害我白费劲