SQL query normalize accents, til

Question

I often have to search for names of products that have accents.. how to normalize this?

In my table I use the collation utf8_general_ci, which serves well for upper and lower case (CI).

Now, accents, are being a problem, this collation already ignores something like, is and, á de a, the problem is (ã->Till) with a,.. what to do?

Answer 1

Try sending a query

SET NAMES utf8;

Personally I solved the same problem by adding after the mysql connection code :

mysql_set_charset("utf8");

or: mysqli_set_charset("utf8");

or the equivalent in POO : $mysqli_link->set_charset("utf8");

And sometimes you’ll have to define the main charset of php adding this code : mb_internal_encoding('UTF-8');

On the HTML client side you have to add the following header data :

<meta http-equiv="Content-type" content="text/html;charset=utf-8" />

To use the JSON AJAX results (for example, using jQuery), you must set the header by adding :

header("Content-type: application/json;charset=utf8");
json_encode(
     some_data
);

That should solve