Installer 10.5 | 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 | DB2
 
DB2
Database schemas for DB2 use character data types. DB2 supports UTF-8 for character data types and UTF-16 for graphic data types.
The table below lists the character sets and sort order recommended by Software AG.
For
Software AG Recommendation
Character set
CCSID 1208 (UTF-8)
My webMethods Server requires this character set.
Graphic Character Set
UTF-16
Sort order
IDENTITY_16BIT
This sort order ensures the same sorting result for both character and graphic data types.
You can check the database configuration using the GET DATABASE CONFIGURATION command.