Issue with utf-8 encoding using PHP + MySQL

php mysql encoding utf-8 multibyte
Adriana picture Adriana · Nov 10, 2009 · Viewed 59.2k times · Source

I moved data from MySQL 4 (they were originally set to latin2 encoding) to MySQL 5 and set encoding to utf-8. It looks good in phpMyAdmin, and utf-8 is okay. However there are question marks instead of some characters on website! The website encoding is also set to utf8 so I dont understand where the problem is.

PHP and HTML files are also set to utf8.

I have no idea...

Answer

Valentin Golev picture Valentin Golev · Nov 10, 2009

try query

SET NAMES utf8

before any query in your application

Related questions

mysqli not setting charset to utf8mb4

Problem found The problem seems to be that $mysqli->set_charset() is not accepting `utf8mb4' as a valid encoding (just as I "speculated" in the first update). MySQL version is 5.5.41 and PHP version is 5.4.41 (no problem with …

Read More
What is the best collation to use for MySQL with PHP?

I'm wondering if there is a "best" choice for collation in MySQL for a general website where you aren't 100% sure of what will be entered? I understand that all the encodings should be the same, such as MySQL, Apache, the …

Read More
Storing a serialized object in MySql database

I have a big php object that I want to serialize and store in a MySql database. The table encoding is UTF-8 and the column to hold the serialized object encoding is also UTF-8. The problem is the object holds …

Read More