webMethods Product Suite  | Complete Installation and Upgrade Information for Software AG Products | Installing Software AG Products | Preparing for Database Component Creation | Database User and Storage, and Database Settings | 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.
Copyright © 2007-2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.