List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:October 20 1999 8:46pm
Subject:hi-ascii comparison doesn't work correctly
View as plain text  
>>>>> "list" == list  <list@stripped> writes:

>> Description:
list> MySQL erraneously thinks certain characters match while they do not.
>> How-To-Repeat:
list> select "y"="ü"
list> (the second character is iso latin-1, value 252)
list> returns 1
>> Fix:
list> The only way around this seems to be to use the BINARY keyword, ie
list> select BINARY "y"="ü" works allright.
list> So the problem probly is somewhere in the conversion from uppercase
list> to lowercase or something.

Hi!

The problem is that here in Sweden the two characters above are sorted 
according to the same value :(

If you need to fix this, you have to add a new character table into
MySQL (or use the binary keyword).  The MySQL manual includes some
information how to do this.

Regards,
Monty
Thread
hi-ascii comparison doesn't work correctlylist20 Oct
  • hi-ascii comparison doesn't work correctlyMichael Widenius20 Oct
    • how to set "EXPLAIN"Irma Esmer21 Oct
      • Re: how to set "EXPLAIN"Bob Kline21 Oct