what is the step to convert a db from latin1 to UTF8
Posted by: housy hou
Date: October 11, 2009 10:04PM

Hi mysql experts,

I have a old db in mysql 5.1, it is using latin1 as characterset.
but while developer using it, they sometimes do "set names utf8" at the beginning of
there sql scripts, now, i need to convert it to UTF8 as a default database characterset, and I also need convert all the tables to UTF8,they are latin1 as they created without specification. My question is , what is the best way?

I read some articles , some one said to mysqldump the database, the reimport again
after you change all latin1 to UTF8 in the dump file.
but someother articles said, you need do iconv to convert the whole encoding format of dump file before doing mysqlimport, I want to ask , is this iconv necessary?

I tried with and without iconv, iconv 's result seems not right at all???

Can some one give me a hint ?

Thanks a lot.

Options: ReplyQuote

Written By
what is the step to convert a db from latin1 to UTF8
October 11, 2009 10:04PM

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.