Migrating from a 'big5' encoded DB to a 'utf-8' one.

[Leszek koltunski]

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!