Page 1 of 1

Convert mysql flooded with gibberish into human format

Posted: Wed Jan 13, 2010 10:11 pm
by 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

Re: Convert mysql flooded with gibberish into human format

Posted: Thu Jan 14, 2010 10:34 am
by 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