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?