Re: Going all UTF-8
Posted by: Shuichi Tamagawa
Date: May 20, 2005 09:19PM

Rickard Andersson wrote:
> OK. So if I change the character set of the table,
> all the existing column will be converted?

Yes.

Note that the following command doesn't convert anything.

ALTER TABLE table_name DEFAULT CHARACTER SET = utf8;

If you want to convert the table definition and data of the existing table, do

ALTER TABLE table_name CONVERT TO CHARACTER SET utf8;

Like KimSeong said, make sure that you take backup before doing that. And do it on testing environment first. Character set conversion always has some risks.

Options: ReplyQuote


Subject
Views
Written By
Posted
3320
May 16, 2005 07:01AM
1961
May 17, 2005 02:20AM
2043
May 17, 2005 04:50AM
1922
May 20, 2005 04:47PM
Re: Going all UTF-8
2679
May 20, 2005 09:19PM
1803
May 23, 2005 04:15AM


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.