Topic: [SOLVED] Russian Text in MySQL and PHP

[cmgmyr]

I have a database that will eventually have to be used for english, russian, spanish, and a few other languages. Right now I'm adding the russian to it, but when it outputs to the PHP page all I get are question marks. It's showing correctly in phpMyAdmin, but not when it's echoed. Can anyone point me in the right direction?

Thanks,
-Chris

[effigy]

Are you using UTF-8 across the board--in your table, meta tag, and during PHP's connection to MySQL?

[cmgmyr]

I have the database and the table set to

Code: [Select]

utf8_unicode_ci this in the header file

Code: [Select]

<meta http-equiv="content-type" content="text/html; charset=utf-8" /> and this right after the database connection

Code: [Select]

$db->query('SET NAMES cp866');

[effigy]

How about:

Code: [Select]

SET NAMES 'utf8'
SET CHARACTER SET utf8'


[cmgmyr]

awesome! worked like a charm! thanks!!!