how to check the charset and collation of mysql database?

Question

how to check the charset and collation of mysql database? or what command to the charset and collation of mysql database?

Thanks

score 2 · Accepted Answer · answered Apr 06 '10 at 05:39

2

Try,

SHOW CREATE DATABASE database-name

And for seeing the collation of tables inside,

SHOW CREATE TABLE table-name

answered Apr 06 '10 at 05:39

Knight Samar

1 Answers1