Dear Wiki user, You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification. The "LocalizingDerbyMessages" page has been changed by lilywei. http://wiki.apache.org/db-derby/LocalizingDerbyMessages?action=diff&rev1=3&rev2=4 -------------------------------------------------- == Localizing Derby Messages == + The English message sources live in the following locations: + ||'''English Message File''' ||'''Description''' || + ||java/engine/org/apache/derby/loc/messages.xml ||Diagnostic messages from the core Derby engine. || + ||java/drda/org/apache/derby/loc/drda/messages_en.properties ||Diagnostic messages from the Network Server. || + ||java/engine/org/apache/derby/loc/toolsmessages.properties ||Diagnostic messages for most Derby tools. || + ||java/engine/org/apache/derby/loc/sysinfoMessages.properties ||Diagnostic messages for the sysinfo tool. || - The English message sources live in the following locations: + - || '''English Message File''' || '''Description''' || - || java/engine/org/apache/derby/loc/messages.xml || Diagnostic messages from the core Derby engine. || - || java/drda/org/apache/derby/loc/drda/messages_en.properties || Diagnostic messages from the Network Server. || - || java/engine/org/apache/derby/loc/toolsmessages.properties || Diagnostic messages for most Derby tools. || - || java/engine/org/apache/derby/loc/sysinfoMessages.properties || Diagnostic messages for the sysinfo tool. || Localizations for other languages live in the same directories as the English versions. Supported languages include: + ||'''Language''' ||'''Engine Message Source''' ||'''Network Server Message Source''' ||'''Tools Message Source''' ||'''Sysinfo Message Source''' || + ||Czech ||messages_cs.properties ||messages_cs.properties ||toolsmessages_cs.properties ||sysinfoMessages_cs.properties || + ||German ||messages_de_DE.properties ||messages_de_DE.properties ||toolsmessages_de_DE.properties ||sysinfoMessages_de_DE.properties || + ||Spanish ||messages_es.properties ||messages_es.properties ||toolsmessages_es.properties ||sysinfoMessages_es.properties || + ||French ||messages_fr.properties ||messages_fr.properties ||toolsmessages_fr.properties ||sysinfoMessages_fr.properties || + ||Hungarian ||messages_hu.properties ||messages_hu.properties ||toolsmessages_hu.properties ||sysinfoMessages_hu.properties || + ||Italian ||messages_it.properties ||messages_it.properties ||toolsmessages_it.properties ||sysinfoMessages_it.properties || + ||Japanese ||messages_ja_JP.properties ||messages_ja_JP.properties ||toolsmessages_ja_JP.properties ||sysinfoMessages_ja_JP.properties || + ||Korean ||messages_ko_KR.properties ||messages_ko_KR.properties ||toolsmessages_ko_KR.properties ||sysinfoMessages_ko_KR.properties || + ||Polish ||messages_pl.properties ||messages_pl.properties ||toolsmessages_pl.properties ||NOT TRANSLATED || + ||Portuguese ||messages_pt_BR.properties ||messages_pt_BR.properties ||toolsmessages_pt_BR.properties ||sysinfoMessages_pt_BR.properties || + ||Russian ||messages_ru.properties ||messages_ru.properties ||toolsmessages_ru.properties ||sysinfoMessages_ru.properties || + ||Chinese (Simplified) ||messages_zh_CN.properties ||messages_zh_CN.properties ||toolsmessages_zh_CN.properties ||sysinfoMessages_zh_CN.properties || + ||Chinese (Traditional) ||messages_zh_TW.properties ||messages_zh_TW.properties ||toolsmessages_zh_TW.properties ||sysinfoMessages_zh_TW.properties || + - || '''Language''' || '''Engine Message Source''' || '''Network Server Message Source''' || '''Tools Message Source''' || '''Sysinfo Message Source''' || - || Czech || messages_cs.properties || messages_cs.properties || toolsmessages_cs.properties || sysinfoMessages_cs.properties || - || German || messages_de_DE.properties || messages_de_DE.properties || toolsmessages_de_DE.properties || sysinfoMessages_de_DE.properties || - || Spanish || messages_es.properties || messages_es.properties || toolsmessages_es.properties || sysinfoMessages_es.properties || - || French || messages_fr.properties || messages_fr.properties || toolsmessages_fr.properties || sysinfoMessages_fr.properties || - || Hungarian || messages_hu.properties || messages_hu.properties || toolsmessages_hu.properties || sysinfoMessages_hu.properties || - || Italian || messages_it.properties || messages_it.properties || toolsmessages_it.properties || sysinfoMessages_it.properties || - || Japanese || messages_ja_JP.properties || messages_ja_JP.properties || toolsmessages_ja_JP.properties || sysinfoMessages_ja_JP.properties || - || Korean || messages_ko_KR.properties || messages_ko_KR.properties || toolsmessages_ko_KR.properties || sysinfoMessages_ko_KR.properties || - || Polish || messages_pl.properties || messages_pl.properties || toolsmessages_pl.properties || NOT TRANSLATED || - || Portuguese || messages_pt_BR.properties || messages_pt_BR.properties || toolsmessages_pt_BR.properties || sysinfoMessages_pt_BR.properties || - || Russian || messages_ru.properties || messages_ru.properties || toolsmessages_ru.properties || sysinfoMessages_ru.properties || - || Chinese (traditional) || messages_zh_CN.properties || messages_zh_CN.properties || toolsmessages_zh_CN.properties || sysinfoMessages_zh_CN.properties || - || Chinese (simplified) || messages_zh_TW.properties || messages_zh_TW.properties || toolsmessages_zh_TW.properties || sysinfoMessages_zh_TW.properties || 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. @@ -39, +41 @@ and a discussion which took place on the [[http://www.nabble.com/-DISCUSS--Process-for-contribution-of-translated-message-files-td18762388.html#a18762388|derby-dev list]]. - The following [[http://mail-archives.apache.org/mod_mbox/www-legal-discuss/200807.mbox/%3c40D37BFE-4104-493D-91ED-63E181441F3C@gbiv.com%3e|post]] sums up the consensus: + The following [[http://mail-archives.apache.org/mod_mbox/www-legal-discuss/200807.mbox/<40D37BFE-4104-493D-91ED-63E181441F3C@gbiv.com>|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 (Traditional, Taiwan) + + . Please use the following option: -Duser.language=zh –Duser.country=TW + + 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) +