UTF-8 from MySQL does not show correctly in PHPPosted: April 6, 2017
The data you have in MySQL is all in UTF-8, you have UTF-8 specified in your HTML, PHP is set up to use UTF-8, but you still get gibberish as output, with question marks showing up on screen instead of correct symbols.
The problem may be that the communication between MySQL and PHP is not happening in UTF-8.
Try telling “SET NAMES ‘utf8′” to MySQL when you initiate the connection, before you run any other queries.
For example, as soon as you establish the connection to database, run this in your script:
mysqli_query( $conection, “SET NAMES ‘utf8′” );