HSQLDB Localization

In an effort to provide OpenOffice.org users with localized HSQLDB error messages (in the form shipped with OOo 2.0, all error messages are English), a call was made to the community to volunteer for translating the error messages from the HSQLDB source into other languages.

So far, we have volunteers (V) and finished translations (F) for the following languages:

(The initial list was stolen from here, feel free to add your own language/name if you want to participate.)

(V) (F)
[ ] [ ] Basque
[X] [X] Brazilian(Pt): Olivier Hallot
[ ] [ ] Catalan
[ ] [ ] Chinese
[X] [X] Czech: Petr Kolesa
[ ] [ ] Danish
[ ] [ ] Finnish
[X] [X] French: Jérôme Paschoud
[X] [X] German: Thomas Kellerer
[ ] [ ] Greek
[ ] [ ] Hindi
[X] [X] Hungarian: Andras Timar
[X] [X] Japanese: foral
[X] [X] Korean: Jinwook Kim
[ ] [ ] Laotian
[ ] [ ] Malaysian
[ ] [ ] Netherlands
[ ] [ ] Norwegian
[ ] [ ] Polish
[ ] [ ] Portugese
[ ] [ ] Romanian
[ ] [ ] Russian
[ ] [ ] Serbian
[ ] [ ] Slovak
[X] [X] Slovenian: Vito Smolej
[ ] [ ] Spanish
[ ] [ ] Tamil
[ ] [ ] Thai
[ ] [ ] Turkish
[X] [ ] Vietnamese: Clytie Siddall

Encoding of the .properties files

The translated sql-error-messages_XX.properties files (XX stands for the language code) should be either in ISO-8859-1 or in plain ASCII with escaped unicode values. The native2ascii executable from Sun JDK can convert files to escaped unicode format. Other text editors on Windows known to handle escaped unicode: UltraEdit 11.20 (shareware), UniRed (freeware), SC Unipad (shareware). There is also a command line tool called uni2ascii which can do the job of converting unicode text files to escaped unicode text.

Download

The current JAR file with the translated error messages can be found at the DBA pages.

• download it to an arbitrary location
• in OOo, go to Tools|Options|OpenOffice.org|Java
• press the "Class Path" button
• add the JAR file you just downloaded to the class path
• close all dialogs with OK
• (re-start OpenOffice.org, if advised so)

Translation Toolkit

Note that you can use prop2po.py from the translate toolkit to convert properties files to PO files. For example,

 prop2po.py -P sql-error-messages.properties -o po/sql-error-messages.pot
 prop2po.py -t sql-error-messages.properties sql-error-messages_it.properties -o po/it.po

this yield files like this:

#: 001
msgid "08001 The database is already in use by another process"
msgstr "08001 L'archivio è in uso da un altro processo"

#: 002
msgid "08003 Connection is closed"
msgstr "08003 Connessione chiusa"

Samples from hsqldb 1.8 here