Re: what is the step to convert a db from latin1 to UTF8
Posted by: housy hou
Date: October 15, 2009 02:12PM

thanks Rick,
I have go through my mysqldb and all the column's length() is same as char_length().

Is that means the work will be simple?

I want to do the conversion on line,
like the method showed in below link:
http://www.mysqlperformanceblog.com/2009/03/17/converting-character-sets/

IS that ok ?

It just run a command like this :
SQL:


ALTER TABLE `t1`

DEFAULT CHARSET=utf8,

MODIFY COLUMN `c1` text CHARACTER SET utf8;

to change all columns.


IS that ok , or should i run like this ?

ALTER TABLE t1 MODIFY first_name varbinary(255);
ALTER TABLE t1 MODIFY first_name varchar(255) CHARACTER SET utf8;
?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: what is the step to convert a db from latin1 to UTF8
3088
October 15, 2009 02:12PM


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.