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.

not sure about this but did you check whether the browser has the encoding installed already? — Michael Mao
– Michael Mao, Commented Aug 5, 2010 at 22:26
Sure you don't have a browser problem? The text at that link renders correctly here, and the document is being correctly detected as UTF-8. — John Flatness
– John Flatness, Commented Aug 6, 2010 at 1:43
@zerocrates, it wasn't browser, I sure tried that. I added SET NAMES and SET CHARACTER_SET to utf8 and it worked. — mvbl fst
– mvbl fst, Commented Aug 18, 2010 at 16:09

Andreas Linden · Accepted Answer · 2010-08-05 22:23:31Z

4

try to execute the following query before loading your data

SET NAMES 'utf8';

answered Aug 5, 2010 at 22:23

Andreas Linden

12.8k7 gold badges54 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

mvds · Accepted Answer · 2010-08-05 22:21:21Z

1

Have you also tried:

set character_set_connection=utf8;

answered Aug 5, 2010 at 22:21

mvds

47.4k8 gold badges104 silver badges113 bronze badges

Comments

bcosca · Accepted Answer · 2010-08-06 01:40:22Z

0

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

answered Aug 6, 2010 at 1:40

bcosca

17.6k5 gold badges43 silver badges51 bronze badges

1 Comment

mvbl fst Over a year ago

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

Collectives™ on Stack Overflow

PHP encoding issue

3 Answers 3

Comments

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Linked

Related