Codementor Events

Avoid Special Characters in Mysql_fetch_array

Published Aug 14, 2017

If mysql_fetch_array() displays special characters on some fields then we can use
mysql_query("SET NAMES 'utf8'");
mysql_query("SET CHARACTER SET utf8");
mysql_query("SET SESSION collation_connection = 'utf8_unicode_ci'");
to solve the issue if its mysqli then use
mysqli>query("SETNAMESutf8");mysqli->query("SET NAMES 'utf8'"); mysqli->query("SET CHARACTER SET utf8");
$mysqli->query("SET SESSION collation_connection = 'utf8_unicode_ci'");
and it will work awesomely perfect

Discover and read more posts from Sridhar Krishnan
get started