Solution for: #26: Switch a MySQL table charset to UTF8
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