Re: Converting to UTF-8 without shell access
Posted by: Rick James
Date: March 15, 2011 09:03PM

Test before production -- Yes, that is a good idea. Even if it is just another copy of the data in another database on the same server. Converting from latin1 to utf8 may be reversible, but if you do something wrong, you could have a mess that is really hard to undo.

CREATE TABLE x LIKE main_db.main_table;
INSERT INTO x SELECT * FROM main_db.main_table;

That should give you a copy of one table. Then you can try one of the conversion techniques. To see what you have apply the HEX() and CHAR_LENGTH() tests in the web page I mentioned.

If that fails, DROP the database, start over, and try another technique.

Options: ReplyQuote

Written By
Re: Converting to UTF-8 without shell access
March 15, 2011 09:03PM

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.