mysql dont recognize the special charset from query use php

Question

i have

$query = "SELECT * FROM movisat.provincias WHERE descripcion LIKE '%coruña%'";    
$rs = mysql_query($sql, db::getConexion());
        print_r(mysql_fetch_assoc($rs));

return:

Array()

and with this it works

$query = "SELECT * FROM movisat.provincias WHERE descripcion LIKE '%coru%'";

$rs = mysql_query($sql, db::getConexion());
        print_r(mysql_fetch_assoc($rs));

return:

without the character "Ñ" it works

You should use UTF8 throughout your application. I have previously written [**an answer with a checklist**](https://stackoverflow.com/questions/31897407/mysql-and-php-utf-8-with-cyrillic-characters/31899827#31899827) (PHP/MySQL) of what you should set to UTF8. For more in-depth, there's [UTF-8 all the way through](https://stackoverflow.com/q/279170/5914775). — Qirel, Mar 18 '19 at 11:01
Note that if the character is broken in the table as well, you need to first fix your charset issues, then reinsert the data with the correct charset. — Qirel, Mar 18 '19 at 11:02
Note that this API was deprecated a really, really long time ago. — Strawberry, Mar 18 '19 at 11:04
i think u need to use `utf8_general_ci` for special characters. — devpro, Mar 18 '19 at 11:11
@WellintongAntonioSotoRamire Read through https://stackoverflow.com/questions/31897407/mysql-and-php-utf-8-with-cyrillic-characters/31899827#31899827 and follow that list. You need to set UTF8 in the database, columns, connection, HTML header, PHP header, file encoding. — Qirel, Mar 18 '19 at 11:14
i get the data from ajax and i serialize the data, is possible that is these the problem? @Qirel — Wellintong Antonio Soto Ramire, Mar 18 '19 at 11:27
$paramsUnserialized = @unserialize($searchParams); if ($paramsUnserialized === false) { $paramsUnserialized = @unserialize(utf8_decode($searchParams)); $paramsUnserialized = array_map('eliminarTildes', $paramsUnserialized ); $paramsUnserialized = array_map('utf8_encode', $paramsUnserialized ); } — Wellintong Antonio Soto Ramire, Mar 18 '19 at 11:30
No, that's not the problem. You shouldn't use `utf8_encode` or decode, you just just *fix* the charset issue. I don't know what your code looks like in full, so I can't say anything specific. — Qirel, Mar 18 '19 at 11:38
Perhaps you didn't specify UTF8 in the mysql connection, in the mysql tables, in PHP, in HTML... Hard to say. See the checklist I linked earlier, and go through it point by point. — Qirel, Mar 18 '19 at 11:38

score 0 · Answer 1 · answered Mar 18 '19 at 13:12

You should specify something like this in your connection parameters:

$con = mysqli_connect(DB_SERVER,DB_USER,DB_PASSWORD,DB_DATABASE);
$con->set_charset("utf8");

When writing Data in your table, use utf8_decode. Example:

$foo = 'dataÄÜè';
$write = utf8_decode($foo);

When you get Data from your Table, use utf8_encode. Example:

$result = 'dataÄÜé';
$print_result = utf8_encode($result);

Hope this helps.

mysql dont recognize the special charset from query use php

1 Answers1