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]

Reply via email to