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://*.com/questions/1049728/how-do-i-see-what-character-set-a-database-table-column-is-in-mysql

How do I see what character set a database / table / column is in MySQL?,布布扣,bubuko.com

How do I see what character set a database / table / column is in MySQL?