When creating or upgrading a database, use this attribute to associate a non-default territory with the database. Setting the territory attribute overrides the default system territory for that database. The default system territory is found using java.util.Locale.getDefault().
Specify a territory in the form ll_CC, where ll is the two-letter language code, and CC is the two-letter country code.
Language codes consist of a pair of lowercase letters that conform to ISO-639. The following table shows some examples.
To see a full list of ISO-639 codes, go to http://www.ics.uci.edu/pub/ietf/http/related/iso639.txt.
Country codes consist of two uppercase letters that conform to ISO-3166. The following table shows some examples.
A copy of ISO-3166 can be found at http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html.
The territory attribute is used only when creating a database.
In the following example, the new database has a territory of Spanish language and Mexican nationality.
You can use the collation attribute with the territory attribute to specify that collation is based on the territory instead of based on Unicode codepoint collation,