Convert mysql flooded with gibberish into human format

[rokka]

Hi,

I have a problem with mysql database, the information there is stored in unreadable format, like this:

81>кий коÑ<81>тел - на фо

The blog itself is functioning because there is a config parameter enabled:

Enable DB-charset conversion
Issues a MySQL "SET NAMES" query to indicate the required charset for the database. Turn this on or off, if you see weird characters in your blog.

The posts are in Russian.
Is there is a way to convert database dump into readable format to switch off "DB-charset conversion"?

Thanks in advance!

--
Roman

[garvinhicking]

Hi!

How do you try to access this? With phpmyadmin?

You just need to make sure your clients sets the UTF-8 charset and not latin1. (just like the config switch does for s9y).

Regards,
Garvin