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.