[SOLVED] Re: Can't get accent insensitive in utf8_general_ci

[Bruno Dassas]

OK ok, i get it, it seems my data where in an incorrect format in the database.

I added the magical :

mysql_query("SET NAMES 'utf8'");

just after opening the connection and now it is working as intended (only have to convert all my previous data).

I had tried this before, but the example I had was incorrectly spelled with 'utf-8' instead of 'utf8' so I thought this wasn't working.