az0000000
22 Sep 2012, 05: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.
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.