Re: UTF8 Fulltext search case sensitive cyrillic

[Francois COLOMBIER]

Hi,

I've had the same problem.
It could have been solved by using COLLATE utf8_bin.

Example :
One entry is mytable is {id=2,name="Azolia",tel="....",.....}

SELECT * FROM mytable WHERE name='azolia';
returns entry where id=2, whereas
SELECT * FROM mytable WHERE name COLLATE utf8_bin ="azolia";
returns nothing.

Regards,
Francois