CODEWITHSUNDEEP
phpmysqlutf-8character-encoding
mvbl fst
mvbl fst

Reputation: 5263

PHP encoding issue

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.

Upvotes: 1

Views: 248

Answers (3)

bcosca
bcosca

Reputation: 17555

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

Upvotes: 0

Andreas Linden
Andreas Linden

Reputation: 12721

try to execute the following query before loading your data

SET NAMES 'utf8';

Upvotes: 4

mvds
mvds

Reputation: 47114

Have you also tried:

set character_set_connection=utf8;

Upvotes: 1

Related Questions