views:

49

answers:

3
+1  Q: 

PHP encoding issue

Hi, 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.

+1  A: 

Have you also tried:

set character_set_connection=utf8;
mvds
+3  A: 

try to execute the following query before loading your data

SET NAMES 'utf8';
zolex
A: 

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

stillstanding
Font didn't matter. All I end up doing was converting tables to UTF-8 and adding mysql_query ("SET NAMES utf8"); mysql_query ("SET CHARACTER_SET utf8"); to MySQL connect code in PHP
SODA