Re: Converting existing database
Posted by: Alexander Barkov
Date: June 08, 2006 05:17AM

This command converts all CHAR, VARCHAR and TEXT columns
at once:

ALTER TABLE t1 CONVERT TO CHARACTER SET utf8;


You can also specify desired collation and the same time:

ALTER TABLE t1 CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

Options: ReplyQuote


Subject
Views
Written By
Posted
2482
May 20, 2006 10:20AM
Re: Converting existing database
1455
June 08, 2006 05:17AM


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.