IBM Books

String comparison

Select a radio button to determine how characters are sorted, merged, and compared.

The string comparison method, or collating sequence, cannot be changed once the database has been created.

Local alphabet:
Items are sorted according to the database locale and characters are compared using the database code set and locale. This is also known as the System Collating Sequence.

Byte for byte:
Items are sorted according to their binary representation. This is also known as the Identity Collating Sequence.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]