Ignoring language accent

[arekanderu]

I have been searching and searching but does anyone have any idea if and how mysql 5.x ignores accent on LIKE searches? The server and the client are set to utf8 and the tables are using ut8_unicode_ci

Appreciate any help

Cheers

[arekanderu]

I've found the problem.....

utf8_general_ci (and utf8_unicode_ci) is accent insensitive but i had to use SET NAMES 'utf8' at the start of the connection before trying to search anything.....and this is no where documented unfortunately.