Mismatch errors in results

[jcloud9]

Hi Guys,

 

I have this problem where i've got a bunch of utf8 asian characters in a database. When i try to do a SELECT query on the table however, multiple results are returned when only one should be returned.

Here's an example.

Suppose there are two entries in the utf8 table "chars" of only 1 column "char"

the two entries are:

噂

時

(in asian characters they are: 噂 and 時)

 

If i do a query such as "SELECT * FROM `chars` WHERE `char`='時'

both results will be returned.

 

Can anyone tell me what i can do to fix this?

 

Thanks a lot!

[btherl]

There is a section on character sets and collation in the manual here:

 

http://dev.mysql.com/doc/refman/5.1/en/charset.html

 

I can't you more than that, due to lack of mysql experience.. but I suspect that setting the appropriate collation order will help.

 

In particular look here:

 

http://dev.mysql.com/doc/refman/5.1/en/charset-collate.html