mysqldump and import back UTF-8
Posted by: qwe123
Date: September 06, 2005 04:36PM

I have a database with default collation latin1....
All data inside it in UTF-8
I export it's data by using mysqldump mydatabase > mydumpfile and all fine untile now.
Right after it I'm restoring it back into *the same database* by using mysql mydatabase < mydumpfile and all non european characters turns into '?'. What to do? Change collation of whole DB - it can make problem with all my data inside (mybe not, i do not want to take chance)
Please advice

Options: ReplyQuote


Subject
Views
Written By
Posted
mysqldump and import back UTF-8
3631
September 06, 2005 04:36PM


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.