System and language-aware collation tables

The default Db2® database collation is SYSTEM. It sorts the items in either ascending or descending order, based on the single weight preassigned to each character.

Starting in Version 9.5, Db2 supports a new set of language-aware collations for the Unicode databases. These collations emulate the ordering behavior of the earlier non-Unicode SYSTEM collations. This allows you to move your existing non-Unicode databases to Unicode and still maintain the current database ordering.

The following tables list the ordering of all the single-byte code points of each non-Unicode code page, along with their Unicode equivalents in UCS-2BE and UTF-8 encodings.