Re: what is the step to convert a db from latin1 to UTF8
Posted by: Rick James
Date: October 15, 2009 07:53PM

I hesitate to say which one to do. Suggest you run some tests...

1. find some rows with accents in them
2. create a table with the _same_ schema; copy the rows into them (INSERT ... SELECT)
3. Try one of the conversions on that table
4. Check the results -- now length and char_length should be different, and should differ by the appropriate amount. Fetch the rows in you application; see if they look right.

Repeat for the other conversion.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: what is the step to convert a db from latin1 to UTF8
2879
October 15, 2009 07:53PM


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.