Migrating from a 'big5' encoded DB to a 'utf-8' one.
Posted by: Leszek koltunski
Date: August 23, 2005 06:35AM

Hello MySQL gurus,

I've got the following problem:

We have a MySQL DB with Chinese stuff inside, encoded with 'big5' charset. Yesterday we upgraded the DB from 4.0.24 to 4.1.13a , and by the occasion, I decided to change the encoding to 'utf-8' .

Before the upgrade, I backed stuff up with 'mysqldump --all-databases > backup.sql' .

Now, the upgrade - I think - went smoothly, meaning that new data can be stored and retrieved properly , incl. the Chinese characters.

The problem, however , is that when I import the old data with 'source backup.sql' , the Chinese characters get mangled and we see '???' when selecting.

I presume this is because the backup.sql still uses 'big5' , whereas the new DB uses 'utf-8' .

How can I remedy this?

Thanks in advance!

Options: ReplyQuote

Written By
Migrating from a 'big5' encoded DB to a 'utf-8' one.
August 23, 2005 06:35AM

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.