jcloud9 Posted March 9, 2007 Share Posted March 9, 2007 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! Quote Link to comment https://forums.phpfreaks.com/topic/41922-mismatch-errors-in-results/ Share on other sites More sharing options...
btherl Posted March 9, 2007 Share Posted March 9, 2007 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 Quote Link to comment https://forums.phpfreaks.com/topic/41922-mismatch-errors-in-results/#findComment-203268 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.