Collation sequences: Use in comparison operations

Updated: April 19, 2023

By default, when QDB compares two text values, the comparison result is determined using memcmp(), regardless of the text encoding. QDB lets you write arbitrary comparison functions, known as user-defined collation routines, to use instead of memcmp().

QDB also features three built-in collation sequences:

BINARY
Compare string data using memcmp(), regardless of text encoding. This is the default comparison method.
NOCASE
The same as BINARY, except that the 26 uppercase characters used by the English language are converted to their lowercase equivalents before the comparison is performed.
RTRIM
The same as BINARY, except that trailing spaces are ignored.

The last two sequences are intended for testing purposes.