Q:
How do I see what the character set that a MySQL database, table and column are in? Is there something like
SHOW CHARACTER SETFOR mydatabase;and
SHOW CHARACTER SETFOR mydatabase.mytable;and
SHOW CHARACTER SETFOR mydatabase.mytable.mycolumn;
A:How do I see what the character set that a MySQL database, table and column are in? Is there something like
SHOW CHARACTER SETFOR mydatabase;and
SHOW CHARACTER SETFOR mydatabase.mytable;and
SHOW CHARACTER SETFOR mydatabase.mytable.mycolumn;参考：
http://stackoverflow.com/questions/1049728/how-do-i-see-what-character-set-a-database-table-column-is-in-mysql