Re: Multibyte string search from non-binary column is not case insensitive
Posted by: Rick James
Date: April 22, 2010 09:45AM

That should have worked. Let's do some debugging.

First, to see exactly what is in the table...
SELECT x, HEX(x), LENGTH(x), CHAR_LENGTH(x) FROM ... WHERE ...
where x is the column with the umlauted A and a.

The two characters should be "equal" under utf8_unicode_ci. I did a similar test successfully:

SELECT x, HEX(x):
| e          | 65               |
| è          | C3A8             |
| é          | C3A9             |
| E          | C388             |
| É          | C389             |
| E          | 45               |
etc
SELECT GROUP_CONCAT(x) ... GROUP BY x:
| e,è,é,E,É,E       |
etc.
x uses utf8_unicode_ci; running 5.1

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Multibyte string search from non-binary column is not case insensitive
1930
April 22, 2010 09:45AM


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.