Re: what is the step to convert a db from latin1 to UTF8
Posted by:
housy hou
Date: October 16, 2009 10:38PM
Dear Rick,
Thanks a lot for your advice. As i follow the issue , i find something.
our developer using "set names utf8" before they insert ,
but db character set is latin1, as my understand, those character insert into db are converted from utf8 format to latin1 style, and non-latin1 data already lost during insert,if i convert the db and data to utf8, i can only save my latin1 encoded data, those non-latin1 code can not be restored ,am i right ?
for conversion to utf8, i need dump the DB using latin1 format, doing iconv to see the right utf8 code, or just dump the db using utf8 ?
i try both, if i dump using latin1 format, i need iconv from latin1 to utf8 to get the right code, if i dump using utf8 format, there will be any trouble during conversion again ? since this time data converted from latin1 to utf8 ?
so the data transfered like this utf8->latin1->utf8 , are there any lost happen using --default-character-set =utf8 to dump , or it is prefer to using --default-character-set=latin1 to dump ,and using iconv to change the format?
Thanks a lot.
Yours friend