Installer 10.7 | Complete Installation and Upgrade Information for Software AG Products | Installing Software AG Products On Premises | Preparing for Database Component Creation | Prepare for Database Component Creation for All RDBMSs | Character Set and Sort Order | MySQL Community Edition and Enterprise Edition
 
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.