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.