UTF8 : LIKE does not support character expansion ?

[Antoine Dinimant]

Hello,

I'm carrying out some tests on UTF8 collations with French language, on MySQL 5.0.22. I have a table named test with an utf8_unicode_ci column, named texte2 ; this column contains words like 'œuvre' (first character is the French 'melt digram oe' 0+0153) or 'groß' (last character is the German 'hard s' 0+00DF).

These queries work as expected, with œ mapping to oe and ß mapping to ss :

SELECT * FROM test WHERE texte2 = 'oeuvre' ;
SELECT * FROM test WHERE texte2 = 'gross' ;

But none of these queries returns any result :

SELECT * FROM test WHERE texte2 LIKE 'o%' ;
SELECT * FROM test WHERE texte2 LIKE '%s' ;
SELECT * FROM test WHERE texte2 LIKE 'oe%' ;
SELECT * FROM test WHERE texte2 LIKE '%ss' ;
SELECT * FROM test WHERE texte2 LIKE 'oeuvre' ;
SELECT * FROM test WHERE texte2 LIKE 'gross' ;

It this normal ? Does any ensuing version correct this ?

Thanks for any feedback !

Antoun