PDA

View Full Version : Exporting SQL database of Latin and Cyrillic content via phpMyAdmin properly



az0000000
22 Sep 2012, 04:27 AM
Hello,
I have a Joomla 1.5 website with articles in English and Russian. I have exported the SQL database via phpMyAdmin using its default values. After importing the database to a new server i found out that all Russian content has a messed up charset, and looks something like this: О «Бездушной Компьютерной» Музыке

Then i have opened the database in Notepad++ and indeed all Cyrillic characters are a mess.

What setting should i set in phpMyAdmin to export the database properly, so Latin and Cyrillic content will be displayed properly?

My Joomla is utf-8, and so is the database.

Thank you.