How do I find out the default server character set in mysql?

mysql character-encoding freebsd
User picture User · Sep 8, 2012 · Viewed 11.7k times · Source

Using MySQL on FreeBSD 8.2. How do I find out the default server character set? Is there some command I can run or file I can check?

UPDATE

Actually I want to know how to find both the default server character set and the current server character set.

Answer

eggyal picture eggyal · Sep 8, 2012

As documented under Server Character Set and Collation:

Initially, the server character set and collation depend on the options that you use when you start mysqld. You can use --character-set-server for the character set. Along with it, you can add --collation-server for the collation. If you don't specify a character set, that is the same as saying --character-set-server=latin1.

The default server character set is therefore Windows-1252, which MySQL calls latin1, unless your copy of MySQL has been compiled with some other default.

The manual goes on to say:

The current server character set and collation can be determined from the values of the character_set_server and collation_server system variables. These variables can be changed at runtime.

Therefore, to discover the server character set currently in use:

SHOW VARIABLES LIKE 'character_set_server'

Related questions

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

What is the (default) charset for: MySQL database MySQL table MySQL column

Read More
Change MySQL default character set to UTF-8 in my.cnf?

Currently we are using the following commands in PHP to set the character set to UTF-8 in our application. Since this is a bit of overhead, we'd like to set this as the default setting in MySQL. Can we do …

Read More
How to convert an entire MySQL database characterset and collation to UTF-8?

How can I convert entire MySQL database character-set to UTF-8 and collation to UTF-8?

Read More