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

Options: ReplyQuote

Written By
Re: what is the step to convert a db from latin1 to UTF8
October 16, 2009 10:38PM

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.