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 | 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.
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.