You can set the locale of a database when you create the database by
specifying the territory=ll_CC attribute. (See
At the same time, you can also specify locale-based collation by using the
collation=collation attribute, and you can specify a particular
collation strength to make the database either case-sensitive or
case-insensitive, or to respect both case and accent in collation. See
Each JVM can support many locales that are independent of the default locale for the JVM. Collation support for these additional locales is provided through the java.text.RuleBasedCollator class and the set of rules for these locales. Refer to the JVM specification for details of how these rules are used to provide locale-specific collation.
The locale-based collation in
Locale-based collation adds some extra processing overhead to all character-based comparison operations.