FunctionThe collation attribute
is an optional attribute that specifies whether collation is based on the
territory specified for the database or Unicode codepoint collation. The valid
values for the collation attribute are: TERRITORY_BASED and
UCS_BASIC. The default collation is Unicode codepoint collation (UCS_BASIC).
The collation attribute can be specified
only when you create a database. You cannot specify this attribute on an existing
database or when you upgrade a database.If you include the collation attribute
with the value TERRITORY_BASED when you create the database,
the collation is based on the language and country codes that you specify
with the territory attribute.
If you do not specify
the territory attribute when you create the database, uses the java.util.Locale.getDefault method
to determine the current value of the default locale for this instance of
the Java Virtual Machine (JVM).
The collation attribute
applies only to user-defined tables. The system tables use the Unicode codepoint
collation.