# Other components with locale support

Derby also provides locale support for the following components:

- Database error messages are in the language of the locale, if support is explicitly provided for that locale with a special library.

  For example, Derby explicitly supports Spanish-language error messages. If a database's locale is set to one of the Spanish-language locales, Derby returns error messages in the Spanish language.

- The Derby tools. In the case of the tools, locale support includes locale-specific interface and error messages and localized data display.

  For more information about localization of the Derby tools, see the Derby Tools and Utilities Guide.

Localized messages require special libraries.

The locale of the database is set by the territory=ll_CC attribute when the database is created. However, the locale of the error messages and tools is not determined by the locale of the database. The locale of the error messages and tools is determined by the default system locale. This means that it is possible to create a database with a non-default locale. In such a case, error messages are not returned in the language of the locale of the database but are returned in the language of the default locale instead.

Note: You can override the default locale for ij with a property on the JVM. For more information, see the Derby Tools and Utilities Guide.
Parent topic: Localizing Derby
Related concepts
SQL parser support for Unicode
Character-based collation in Derby
Messages libraries