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

 

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?

上一篇:基于任务的vim使用手册-基础篇


下一篇:三类传感器助力保证无人驾驶安全