My table's collation is utf8_general_ci.
My pages are encoded with UTF-8 (without BOM).
Within my pages, my Equiv meta tag sets character set to utf8
My data has Turkish characters in it.
When i output them, it's not showing them as it should be but when i do $db->set_charset("utf8");
, it works.
Why do i have to use $db->set_charset("utf8");
even though everything is utf-8 encoded?
The data is stored as UTF-8 in MySQL, but the PHP's client connection collation is not. Which is why you have to use
set_charset
in PHP for the DB connection.Update
php.ini : default_charset utf-8
.htaccess : AddDefaultCharset utf-8