Re: Going all UTF-8
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.
Subject
Views
Written By
Posted
3416
May 16, 2005 07:01AM
2011
May 17, 2005 02:20AM
2094
May 17, 2005 04:50AM
1976
May 20, 2005 04:47PM
Re: Going all UTF-8
2725
May 20, 2005 09:19PM
1860
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.