On 11/28/05, sheeri kritzer <[EMAIL PROTECTED]> wrote: > Hi there, > > On my system, I have the following in my show charset (I eliminated > the ones that didn't deal with chinese, so this is a partial listing) > > mysql> show charset; > +----------+-----------------------------+---------------------+--------+ > | Charset | Description | Default collation | Maxlen | > +----------+-----------------------------+---------------------+--------+ > | big5 | Big5 Traditional Chinese | big5_chinese_ci | 2 | > | gb2312 | GB2312 Simplified Chinese | gb2312_chinese_ci | 2 | > | gbk | GBK Simplified Chinese | gbk_chinese_ci | 2 | > +----------+-----------------------------+---------------------+--------+ > > Your system may differ, but if you look at all the descriptions, > you'll probably find one that uses chinese. > > As for collations: > > mysql> show collation like "%hinese%"; > +-------------------+---------+----+---------+----------+---------+ > | Collation | Charset | Id | Default | Compiled | Sortlen | > +-------------------+---------+----+---------+----------+---------+ > | big5_chinese_ci | big5 | 1 | Yes | Yes | 1 | > | gb2312_chinese_ci | gb2312 | 24 | Yes | Yes | 1 | > | gbk_chinese_ci | gbk | 28 | Yes | Yes | 1 | > +-------------------+---------+----+---------+----------+---------+ > 3 rows in set (0.00 sec) > > hope this helps! > > -Sheeri > > On 11/22/05, Gu Lei <[EMAIL PROTECTED]> wrote: > > Hello: > > > > I created tables with CHARACTER SET=utf8. And stored Chinese in them. > > > > When I used SELECT * FROM ... ORDER BY ... > > I can't get the right order. > > But when I used CHARACTER SET=gbk, I can get the right order. > > > > I didn't see 'Chinese' or 'China' when SHOW COLLATION. > > > > What can I do? > > > > Thanks. > > > > Regards, > > gu lei > > > > -- > > 祝 事业有成,家庭和睦,身体健康,一切吉祥 > > > > 古雷 > > ------------------------------------------- > > 中企动力科技集团 > > 技术事业发展部___技术架构部 > > \__企业IP通讯部 > > 电话:010 58022278-302 > > 地址:北京亦庄经济技术开发区北工大软件园 > > (地盛北街1号)A区3号楼 > > 邮编:100176 > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > >