Collating Information (collate_info)

This parameter can only be displayed using the GET DATABASE CONFIGURATION API. It cannot be displayed through the command line processor or the Control Center.

Configuration Type

Database

Parameter Type

Informational

This parameter provides 260 bytes of database collating information. The first 256 bytes specify the database collating sequence, where byte "n" contains the sort weight of the code point whose underlying decimal representation is "n" in the code page of the database.

The last 4 bytes contain internal information about the type of the collating sequence. You can treat it as an integer applicable to the platform of the database. There are three values:

• 0 - The sequence contains non-unique weights
• 1 - The sequence contains all unique weights
• 2 - The sequence is the identity sequence, for which strings are compared byte for byte.

If you use this internal type information, you need to consider byte reversal when retrieving information for a database on a different platform.

You can specify the collating sequence at database creation time.