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]