PHP encoding issue

Question

I have a trouble displaying Cyrillic characters properly. Looked in forums, tried a few different thing and nothing works.

Site runs on PHP / MySQL.

MySQL tables charset is utf8, and collation is utf8_general_ci Name entry in DB looks correct (in PhpmyAdmin): Sasha Рукина

Output on page http://www.sodaq.com/: Sasha ??????

Inside PHP I use:

mb_internal_encoding("UTF-8"); mb_http_output("UTF-8");

And send HTTP header 'Content-type: text/html; charset=utf-8'

Still, shows '????' instead of normal characters.

Please help.

Answer 1

try to execute the following query before loading your data

SET NAMES 'utf8';

Answer 2

Have you also tried:

set character_set_connection=utf8;

Answer 3

You didn't mention the font you're using, but it's a big factor. Not all fonts contain all character sets.