MySQL: Script to find default Character Set for Database, Table and Column

In this post, I am sharing scripts find default character set of a MySQL Database, Table and Column.

Generally during the process of database migration, we are checking default character set and collation at MySQL Server level.

But in our production MySQL Server, I have also found that some of table has different character set which was actually not required.

As a database professional, this is our responsibility to maintain consistency between all database objects.

Find default Characater Set for Database:

Find default Characater Set for Table:

Find default Character Set for Column:

Please Visit Other Related Articles !
Database Theory: What is Character Set and Collation
MySQL: How to change default Character set to UTF-8
MySQL: Perform Case Sensitive string comparison

Anvesh Patel

Leave a Reply

Be the First to Comment!

Notify of