Troubles with cyrillic encoding in PHP MySQL site

Question

Have a problem with the cyrillic encoding cyrillic data from mysql displayed correct, but when I add some cyrillic text on the page I get someting like this С‹РІР°Р°Р°РїРІ

data in MySQl - utf8_general_ci

php file:

header('Content-Type: text/html; charset=windows-1251'); 

mysql_query('SET NAMES cp1251');

Have you tried `charset=utf-8` in your header? – Bart Friederichs Mar 09 '13 at 13:19 — Bart Friederichs, Mar 09 '13 at 13:19

score 4 · Accepted Answer · edited Mar 31 '13 at 01:30

4

You're adding the text in utf-8, while your page in 1251.
So, set your editor into Windows-1251 when adding text

OR

change your headers from 1251 to utf-8

header('Content-Type: text/html; charset=utf-8'); 
mysql_query('SET NAMES utf8');

edited Mar 31 '13 at 01:30

Ivan Z

1,517
1
16
25

answered Mar 09 '13 at 13:21

Your Common Sense

156,878
40
214
345

"..So, set your editor into Windows-1251 when adding text" oh! yes of course – jhenya-d Mar 09 '13 at 13:36

Troubles with cyrillic encoding in PHP MySQL site

1 Answers1