#26: Switch a MySQL table charset to UTF8
Solved!on March 16, 2009, 11:17 PM UTC — from 
yliu ( 1,114 views )
yliu ( 1,114 views )
I would like to switch a MySQL table or database to the UTF-8 character set, after it has already been created as Latin1.
Use the "CONVERT TO" syntax
- yliu on March 16, 2009, 11:18 PM UTC
ALTER TABLE foo CONVERT TO CHARACTER SET utf8;References used:
yk's stuff: MySQL: CHARSET from latin1 to utf8
( http://yoonkit.blogspot.com/2006/03/mysql-charset-from-latin1-to-utf8.html ) - found by
yliu on March 16, 2009, 11:19 PM UTC
Think you've got a better solution? Help yliu out by posting your solution
yk's stuff: MySQL: CHARSET from latin1 to utf8
http://yoonkit.blogspot.com/2006/03/mysql-charset-from-latin1-to-utf8.html - found by yliu on March 16, 2009, 11:19 PM UTC
Solution in the comments section is more useful than the one proposed in the post