MySQL Forums
Forum List  »  Character Sets, Collation, Unicode

Advanced Search
New Topic

Re: Change Collation / Charset
Posted by: Alexander Barkov
Date: April 14, 2011 12:17PM

Use

ALTER TABLE t1 CONVERT TO CHARACTER SET utf8;

for every table.

(Don't forget to backup data before converting).

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Change Collation / Charset
6487
Christoph Tietz
March 11, 2011 05:55PM
Re: Change Collation / Charset
2634
Rick James
March 12, 2011 11:46PM
Re: Change Collation / Charset
2559
Christoph Tietz
March 13, 2011 07:58AM
Re: Change Collation / Charset
2214
Alexander Barkov
April 14, 2011 12:17PM
Re: Change Collation / Charset
2053
Christoph Tietz
April 14, 2011 12:45PM


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.