A:s and Ä:s are all the same to utf8??
Posted by: i6791
Date: February 26, 2005 03:48AM

Hello,

I've started to use utf8 in my database instead of national character sets and I can't get the behaviour of MySQL when it treats letters with and without umlauts as if they were the same.

For example,

select my_column from my_table where my_column like "ää%";

brings both strings starting with "aa" and "ää". Similarly,

select my_column from my_table where my_column like "aa%";

brings both "aa"s and "ää"s.

Adding the magic word "binary" to the query of course helps, but then the search is strictly case-sensitive, which is not always desirable.

What's the problem?

I got MySQL 4.1.10-win32. The system is fully optimised to work with utf8. All the necessary variables are set to utf8. The description of the table ends in "default character set utf8". The data itself is in utf8.
The result is the same whether I execute the script from the shell or through Perl and stuff. The query itself and the resulting strings are displayed correctly in the browser.

Any help would be appreciated!! Thanks in advance!

Desperate user

Options: ReplyQuote


Subject
Views
Written By
Posted
A:s and Ä:s are all the same to utf8??
3771
February 26, 2005 03:48AM
2455
February 28, 2005 05:56PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.