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;
> +--+-+---
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.
Rega
