Possible to convert charsets? Help needed!
Posted by: 0zz NoName
Date: September 01, 2005 11:01PM

The problem in short:
I've backed up my forum's DB (from MySQL 4.1.11) which mainly consisted of cyrillic data (usernames, topics, etc.), using default settings (I did not have any options on selecting CHARSET, and the database got converted in latin1_swedish_ci)..

So, after restoration on a different server, all data in cyrillic became unreadable. The hoster could not help: we tried to convert DB and tables using ALTER command, using set_charset when connecting to DB, it is not readable even in PHPMyAdmin.. We tried both: cp1251 and utf8...

I also tried everthing on local machine - no results..

The worst thing - I cannot read cyrillic data even in Notepad (or other relevant software) - tried to use miscellanious converters, but none can recognize cyrillic texts.. Although comments in backup are in cyrillic utf8 and can be read.

My question is: can the data be somehow restored? It is very important as I can lose all forum topics and messages and all registered users..

Besides, can the data be restaoured in MySQL 4.0 - where there is no SET CHARSET command?

Thank you very much for your replies!

Options: ReplyQuote

Written By
Possible to convert charsets? Help needed!
September 01, 2005 11:01PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.