How to Find a Sort Order ID

To find a sort order ID, search the sort order file for “ID”.

For example, use the following command if you want the sort order ID for “Dictionary order, case insensitive” for character set iso_1 (the sort order file name is nocase.srt):

UNIX:

% cd $SYBASE/$SYBASE_ASE/charsets/iso_1
% grep ID nocase.srt

id = 0x34    ; Unique ID # (52) for the sort order

OpenVMS:

$ set default sybase_system:[sybase.charsets.iso_1]
$ search nocase.srt ID

******************************
SYBASE1150_SYSTEM:[SYBASE.CHARSETS.ISO_1]NOCASE.SRT;1
id = 0x34               ; Unique ID # (52) for the sort order