# derby.ui.locale property

The `derby.ui.locale` property specifies an alternative supported locale name when you use one of the Derby tools with a language not supported by your default system.

The locale determines the localized display format for numbers, dates, times, and timestamps, as well as the language of the messages from the Derby tools.

This property is commonly used in conjunction with the `derby.ui.codeset` property.

## Syntax

    derby.ui.locale=derbyval

where derbyval is a supported locale name, in the form ll_CC, where ll is the two-letter language code, and CC is the two-letter country code; for example, `ja_JP`.

## Example

The following command runs `ij` using the Japanese locale (`derby.ui.locale=ja_JP`) and Japanese Latin Kanji mixed encoding (`derby.ui.codeset=Cp939`):

    java -Dderby.ui.locale=ja_JP -Dderby.ui.codeset=Cp939 \
    -Dij.protocol=jdbc:derby: org.apache.derby.tools.ij

Language codes consist of a pair of lowercase letters that conform to ISO 639-1. The following table shows some examples.

Table 1. 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.loc.gov/standards/iso639-2/php/code_list.php.

Country codes consist of two uppercase letters that conform to ISO 3166. The following table shows some examples.

Table 2. 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://userpage.chemie.fu-berlin.de/diverse/doc/ISO_3166.html.

Parent topic: ij properties reference
Related reference
ij.connection.connectionName property
ij.database property
ij.dataSource property
ij.exceptionTrace property
ij.maximumDisplayWidth property
ij.outfile property
ij.password property
ij.protocol property
ij.protocol.protocolName property
ij.showErrorCode property
ij.showNoConnectionsAtStart property
ij.showNoCountForSelect property
ij.URLCheck property
ij.user property
derby.ui.codeset property