Sybase DC35823-01-1500-04 manual Your character set definition files, Sort order name Description

CHAPTER 7 Customizing Localization for Adaptive Server

		Sort orders are located in sort order definition files (.srt files) that accompany
		your character set definition files.
		Note Available sort orders vary according to the character set installed on
		Adaptive Server.
		You can see the available sort orders for your character set by looking in the
		.srt file for your language. Sort orders are stored in:
		$SYBASE/charsets/<charset_name>/*.srt
		For more information about localization files, see “Localization directories”
		on page 94.
		Table 7-16 describes the sort orders that you can specify at installation time or
		at a later time using the sqlloc utility.
		Table 7-16: Sort orders available in Adaptive Server
Sort order name	Description
Binary order	Sorts all data according to numeric byte values for that character set. Binary order sorts
	all ASCII uppercase letters before lowercase letters. Accented or ideographic
	(multibyte) characters sort in their respective standards order, which may be arbitrary.
	All character sets have binary order as the default. If binary order does not meet your
	needs, you can specify one of the other sort orders either at installation or at a later time
	by, using the sqlloc utility.
Dictionary order, case	Case sensitive. Sorts each uppercase letter before its lowercase counterpart, including
sensitive, accent sensitive	accented characters. Recognizes the various accented forms of a letter and sorts them
	after the associated unaccented letter.
Dictionary order, case	Case-insensitive dictionary sort order. Uppercase letters are equivalent to their
insensitive, accent	lowercase counterparts and are intermingled in sorting results.
sensitive
Dictionary order, case	Case-insensitive dictionary sort order. Diacritical marks are ignored.
insensitive, accent
insensitive

Configuration Guide 91