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;
Nice! Thanks for sharing!
Joseph
April 3, 2009 at 8:01 pm