Convert mysql flooded with gibberish into human format
Posted: Wed Jan 13, 2010 10:11 pm
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
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