MySQL Community Edition and Enterprise Edition
The server character set and collation are used as default values if the database character set and collation are not specified in CREATE DATABASE statements. They have no other purpose.
You can determine the current server character set and collation settings from the values of the character set server and collation server system variables. You can change these variables at runtime.
The table below lists the character set and sort order recommended by Software AG.
For | Software AG Recommendation |
Character set | UTF-8 |
Collation | utf8_general_ci |
You can check the database configuration using the SHOW VARIABLES LIKE command.