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.
Subject
Views
Written By
Posted
7529
October 11, 2009 10:04PM
3311
October 12, 2009 09:44PM
4997
October 14, 2009 10:34PM
3089
October 15, 2009 02:12PM
Re: what is the step to convert a db from latin1 to UTF8
2914
October 15, 2009 07:53PM
3903
October 16, 2009 10:39PM
2758
October 16, 2009 10:40PM
3402
October 16, 2009 10:38PM
3112
October 17, 2009 07:01PM
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.