With Unicode codepoint collation (UCS_BASIC), the default if you do not
specify either collation=collation or territory=ll_CC, the numeric
values of the Unicode encoding of the characters are used directly for ordering.
For example, the FRUIT table contains the NAME column that uses the VARCHAR(20)
data type. The contents of the NAME column are:
UCS_BASIC collation sorts all uppercase letters before lowercase
letters. The statement
The above result also appears if you specify territory=ll_CC but do not specify collation=collation.
If the database is created with the territory=ll_CC attribute
set to en_US (English language, United States country code) and the
collation=collation attribute set to TERRITORY_BASED, the statement
The collation set for the database also impacts comparison operators
on character data types. For example, the statement
For information on creating case-insensitive databases, see