MySQL : Find out and change charset of a table

show create table TABLE_IN_QUESTION;
-- show create table can tell you more than 
-- describe TABLE_IN_QUESTION including database engine
-- look towards the end for CHARSET=XXX
alter table TABLE_IN_QUESTION CONVERT TO CHARACTER SET latin1;
One Response
  1. April 3, 2009