territory=ll_CC
territory=ll_CC
Function
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 lower case letters that conform to ISO-639.
Table 26. Sample Language Codes
| Language Code | Description |
|---|---|
| de | German |
| en | English |
| es | Spanish |
| ja | Japanese |
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.
Table 27. Sample Country Codes
| Country Code | Description |
|---|---|
| DE | Germany |
| US | United States |
| ES | Spain |
| MX | Mexico |
| JP | Japan |
A copy of ISO-3166 can be found at http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html.
Combining with Other Attributes
The territory attribute is used only when creating a database.
Example
In the following example, the new database has a territory of Spanish language and Mexican nationality.
jdbc:derby:MexicanDB;create=true;territory=es_MX
Previous Page
Next Page
Table of Contents
Index