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
7679
October 11, 2009 10:04PM
3359
October 12, 2009 09:44PM
5068
October 14, 2009 10:34PM
3127
October 15, 2009 02:12PM
Re: what is the step to convert a db from latin1 to UTF8
2949
October 15, 2009 07:53PM
3946
October 16, 2009 10:39PM
2803
October 16, 2009 10:40PM
3465
October 16, 2009 10:38PM
3171
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.