Sort orders
92 Adaptive Server Enterprise
To see the sort orders that are available, use sqlloc to display the sort orders for the character sets you plan to use. For more information on unicode sort orders for utf_8, see Chapter 7, “Configuring Character Sets, Sort Orders, and Languages” in the System Administration Guide.Dictionary order, case
insensitive with
preference
Case-insensitive dictionary sort order, with case preference for collating purposes. A
word written with uppercase letters is equivalent to the same word written with
lowercase letters.
Uppercase and lowercase letters are distinguished only when you use an order by
clause. The order by clause sorts uppercase letters before it sorts lowercase.
Note Do not select this sort order unless your installation requires that uppercase letters
be sorted before lowercase letters in otherwise equivalent strings for order by clauses.
Using this sort order may reduce performance in large tables when the columns
specified in an order by clause match the key of the table’s clustered index.
Alternate dictionary
order, case sensitive Case-sensitive alternate dictionary sort order with lowercase variants sorted before
uppercase.
Use with several of the Western European languages.
Alternate dictionary
order, case insensitive,
accent insensitive
Case-insensitive and accent-insensitive alternate dictionary sort order.
Use with several of the Western European languages.
Alternate dictionary
order, case insensitive,
uppercase preference
Case-insensitive alternate dictionary sort order with uppercase preference.
Use with several of the Western European languages.
Spanish dictionary order,
case sensitive Case-sensitive Spanish dictionary sort order.
Use with Spanish and for most Latin American locales.
Spanish dictionary order,
case insensitive Spanish case-insensitive dictionary sort order.
Use with Spanish and for most Latin American locales.
Spanish dictionary order
case insensitive, accent
insensitive
Spanish case-insensitive and accent-insensitive dictionary sort order.
Use with Spanish and for most Latin American locales.
Scandinavian dictionary
order, case sensitive Case-sensitive dictionary sort order.
Use with Scandinavian languages.
Scandinavian dictionary
order, case insensitive,
uppercase preference
Case-insensitive and accent-insensitive dictionary sorting, with uppercase preference.
Use with Scandinavian languages.
Sort order name Description