[SOLVED] Cryllic is showing up as ???

[JREAM]

What is the story about Cryllic does anyone know?

 

I have my Charset UTF-8 and my DB Latin Swedish CI.

I don't write Cryllic, I just copy pasted text from Wikipedia and it appears fine.

 

But I have one guy doing real Cryllic, and he is getting all Question marks.

Does anyone know how this works?

Do I change the DB type or something?

 

 

[gizmola]

Hmm well I think your problem could be traced back to the fact that UTF-8 and Latin Swedish CI are two different character sets?  Yes, the best solution is to have your character sets match across the board.

[Nix]

You should use utf8_unicode_ci as charset for any table in order to use Cyrillic characters... Also, be sure you've placed this meta in r document:

<meta http-equiv="Content-Type" content="text/html; charset=utf-8">

 

Or, if even then fails, try defining the charset for use with queries:

$query = "SELECT something FROM somewhere WHERE id = 1";
mysql_query("SET CHARACTER SET utf8");
mysql_query("SET NAMES utf8");
$result = mysql_query($query) or die(mysql_error());

 

cheers!