Home / Database Structure / Data Types / Question No: 104

I need to know the default charater set of MySQL.  Is there way to get this?

MySQL's default Character Set is latin1 that is also known as ISO-8859-1. The latin1 Character Set uses one byte per character.  To get the current database character set, you may run the following query in any MySQL client tool like Query Browser or phpMyAdmin etc:

SHOW VARIABLES LIKE 'character_set_database';

To know MySQL Server default Character Set:

SHOW VARIABLES LIKE 'character_set_server';