LocalizingDerbyMessages

Localizing Derby Messages

The English message sources live in the following locations:

Localizations for other languages live in the same directories as the English versions. Supported languages include:

Typically, as the community develops a new feature release, more messages accumulate in the English message sources. Those English versions need to be localized. Those localizations, in turn, typically turn up in follow-on maintenance releases. Localizations are more up-to-date for some languages than for others.

Typically, localizations for several languages are provided by committers who work for large companies and who have access to their companies' translation teams. Although this translating work happens outside the Derby community, committers checkin this contribution by proxy, under section 4 of their ICLAs.

This process reflects the consensus of two discussions which took place on the legal-discuss mailing list:

• Blanket software grant
• Question about handling external updates to contributed files

and a discussion which took place on the derby-dev list.

The following post sums up the consensus:

"If you have permission from your company, you can contribute them under your own ICLA. However, it is better for your sake (not Apache's) that you have a signed CCLA in place that formally says you have permission to commit stuff that is copyright the company. Only one CCLA is needed for all such commits."

To test Chinese (Traditional, Taiwan) or (Simplified, PRC) for Derby on Windows 7

1. Setting up the system:

• Make sure you have Chinese (Traditional, Taiwan) language pack installed on your Windows 7 machine.

  Go to Control Panel->Clock, Language, and Region->Install or uninstall display languages->Install display languages->Launch Windows Updates (This is some screen shop in turn of what you can download http://windows7center.com/news/windows-7-rtm-language-packs-now-available-via-windows-update/)

2. Change system locale to use Chinese (Traditional, Taiwan):

• Go to Control Panel->Clock, Language, and Region->Install or uninstall display languages->Administrative->Change System Locale->Choose Chinese (Traditional, Taiwan)

3. Setup ij to displaye Chinese (Traditional, Taiwan)

• Please use the following option for org.apach.derby.tools.ij: -Dderby.ui.locale=zh_TW –Dderby.ui.codeset=big5

4. Setup derby server (database side) to display Chinese (Traditional, Taiwan)

• -Duser.language=zh –Duser.country=TW

For example:

$ java -Duser.language=zh -Duser.country=TW org.apache.derby.tools.ij -p derby.

properties

ij 版本 10.7

ij> connect 'jdbc:derby:aa';

錯誤 XJ004：找不到資料庫 'aa'。

ij> connect 'jdbc:derby:test_chinese;create=true;user=REFRESH;password=Refresh';

ij> select * from 家長;

錯誤 42Y07：綱目 'REFRESH' 不存在。

ij> create table 中文(stroke int, 字 varchar(4));

已插入/更新/刪除 0 列

ij> insert into 中文 values (1, '國');

• 已插入/更新/刪除 1 列

ij> insert into 中文 values (2, '生', '09-17-2010');

• 錯誤 42802：指派的值數目與指定的或隱含的直欄數不相同

To test Chinese (Simplified, PRC) for Derby on Windows 7

1. Have Chinese (Simplified, PRC) installed.

(A detail instruction on install Chinese (Simplified, PRC) can be found in:

http://windows7center.com/tutorials/how-to-download-and-install-windows-7-beta-language-packs-mui-packs/

2. Change system locale to Chinese (Simplified, PRC)

3. Setup ij to display Chinese (Simplified, PRC)

• Please use the following option:
• -Dderby.ui.locale=zh_CN –Dderby.ui.codeset=GB2312

4. Setup derby server (database side) to display Chinese (Simplified, PRC)

• Please use the following option:
• -Duser.language=zh –Duser.country=CN

For example:

$ java -Duser.language=zh -Duser.country=CN org.apache.derby.tools.ij -p derby.

properties

ij 版本 10.7

ij> connect 'jdbc:derby:test_cn;create=true;user=REFRESH;password=Refresh';

ij> values current_date;

1

2010-09-11

已选择 1 行

ij> select * from aa;

错误 42Y07：模式“REFRESH”不存在。

ij> create table 登录 (输入 int, 记录 varchar(4));

已插入／更新／删除 0 行

ij> insert into 登录 values (1, '北京');

已插入／更新／删除 1 行

ij> insert into 登录 values (1, '重庆', '广州');

错误 42802：已分配值的数目与指定列或暗指列的数目不同。

One can also use java program to look at the messages_zh_CN.properties. Please use –Dfile.encoding=Cp939 for Chinese (Simplified, PRC ) and –Dfile.encoding=Cp950 for Chinese(Traditional, Taiwan)