DB2 for LUW

Complete Installation and Upgrade Information for Software AG Products : Installing Software AG Products : Creating and Dropping Database Components : Preparing for Database Component Creation : Character Set and Sort Order : DB2 for LUW

DB2 for LUW

Database schemas for DB2 use character data types. DB2 supports UTF-8 for character data types and UTF-16 for graphic data types. Software AG recommends these character sets and sort order:

For...	Software AG recommends...
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.

Contact Support | Community | Feedback