Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 31909 invoked from network); 11 Sep 2010 17:42:47 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 11 Sep 2010 17:42:47 -0000 Received: (qmail 11503 invoked by uid 500); 11 Sep 2010 17:42:47 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 11435 invoked by uid 500); 11 Sep 2010 17:42:46 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" List-Id: Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 11428 invoked by uid 99); 11 Sep 2010 17:42:46 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 11 Sep 2010 17:42:46 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.131] (HELO eos.apache.org) (140.211.11.131) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 11 Sep 2010 17:42:45 +0000 Received: from eosnew.apache.org (localhost [127.0.0.1]) by eos.apache.org (Postfix) with ESMTP id 6BF93353 for ; Sat, 11 Sep 2010 17:42:17 +0000 (UTC) MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable From: Apache Wiki To: Apache Wiki Date: Sat, 11 Sep 2010 17:42:16 -0000 Message-ID: <20100911174216.51421.64416@eosnew.apache.org> Subject: =?utf-8?q?=5BDb-derby_Wiki=5D_Update_of_=22LocalizingDerbyMessages=22_by_?= =?utf-8?q?lilywei?= 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=3Ddiff&rev1= =3D3&rev2=3D4 -------------------------------------------------- =3D=3D Localizing Derby Messages =3D=3D + The English message sources live in the following locations: + ||'''English Message File''' ||'''Description''' || + ||java/engine/org/apache/derby/loc/messages.xml ||Diagnostic messages fro= m 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 ||Diagnosti= c 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 f= rom the core Derby engine. || - || java/drda/org/apache/derby/loc/drda/messages_en.properties || Diagnost= ic messages from the Network Server. || - || java/engine/org/apache/derby/loc/toolsmessages.properties || Diagnosti= c messages for most Derby tools. || - || java/engine/org/apache/derby/loc/sysinfoMessages.properties || Diagnos= tic messages for the sysinfo tool. || = Localizations for other languages live in the same directories as the Eng= lish versions. Supported languages include: + ||'''Language''' ||'''Engine Message Source''' ||'''Network Server Messag= e 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 ||toolsm= essages_de_DE.properties ||sysinfoMessages_de_DE.properties || + ||Spanish ||messages_es.properties ||messages_es.properties ||toolsmessag= es_es.properties ||sysinfoMessages_es.properties || + ||French ||messages_fr.properties ||messages_fr.properties ||toolsmessage= s_fr.properties ||sysinfoMessages_fr.properties || + ||Hungarian ||messages_hu.properties ||messages_hu.properties ||toolsmess= ages_hu.properties ||sysinfoMessages_hu.properties || + ||Italian ||messages_it.properties ||messages_it.properties ||toolsmessag= es_it.properties ||sysinfoMessages_it.properties || + ||Japanese ||messages_ja_JP.properties ||messages_ja_JP.properties ||tool= smessages_ja_JP.properties ||sysinfoMessages_ja_JP.properties || + ||Korean ||messages_ko_KR.properties ||messages_ko_KR.properties ||toolsm= essages_ko_KR.properties ||sysinfoMessages_ko_KR.properties || + ||Polish ||messages_pl.properties ||messages_pl.properties ||toolsmessage= s_pl.properties ||NOT TRANSLATED || + ||Portuguese ||messages_pt_BR.properties ||messages_pt_BR.properties ||to= olsmessages_pt_BR.properties ||sysinfoMessages_pt_BR.properties || + ||Russian ||messages_ru.properties ||messages_ru.properties ||toolsmessag= es_ru.properties ||sysinfoMessages_ru.properties || + ||Chinese (Simplified) ||messages_zh_CN.properties ||messages_zh_CN.prope= rties ||toolsmessages_zh_CN.properties ||sysinfoMessages_zh_CN.properties || + ||Chinese (Traditional) ||messages_zh_TW.properties ||messages_zh_TW.prop= erties ||toolsmessages_zh_TW.properties ||sysinfoMessages_zh_TW.properties = || = + = - || '''Language''' || '''Engine Message Source''' || '''Network Server Mes= sage Source''' || '''Tools Message Source''' || '''Sysinfo Message Source''= ' || - || Czech || messages_cs.properties || messages_cs.properties || toolsmess= ages_cs.properties || sysinfoMessages_cs.properties || - || German || messages_de_DE.properties || messages_de_DE.properties || to= olsmessages_de_DE.properties || sysinfoMessages_de_DE.properties || - || Spanish || messages_es.properties || messages_es.properties || toolsme= ssages_es.properties || sysinfoMessages_es.properties || - || French || messages_fr.properties || messages_fr.properties || toolsmes= sages_fr.properties || sysinfoMessages_fr.properties || - || Hungarian || messages_hu.properties || messages_hu.properties || tools= messages_hu.properties || sysinfoMessages_hu.properties || - || Italian || messages_it.properties || messages_it.properties || toolsme= ssages_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 || to= olsmessages_ko_KR.properties || sysinfoMessages_ko_KR.properties || - || Polish || messages_pl.properties || messages_pl.properties || toolsmes= sages_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 || toolsme= ssages_ru.properties || sysinfoMessages_ru.properties || - || Chinese (traditional) || messages_zh_CN.properties || messages_zh_CN.p= roperties || toolsmessages_zh_CN.properties || sysinfoMessages_zh_CN.proper= ties || - || Chinese (simplified) || messages_zh_TW.properties || messages_zh_TW.pr= operties || toolsmessages_zh_TW.properties || sysinfoMessages_zh_TW.propert= ies || = = 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#a187= 62388|derby-dev list]]. = - The following [[http://mail-archives.apache.org/mod_mbox/www-legal-discus= s/200807.mbox/%3c40D37BFE-4104-493D-91ED-63E181441F3C@gbiv.com%3e|post]] su= ms up the consensus: + The following [[http://mail-archives.apache.org/mod_mbox/www-legal-discus= s/200807.mbox/<40D37BFE-4104-493D-91ED-63E181441F3C@gbiv.com>|post]] sums u= p 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 comm= it stuff that is copyright the company. Only one CCLA is needed for all su= ch commits." = + __To test Chinese (Traditional, Taiwan) or (Simplified, PRC) for Derby o= n Windows 7__ + = + 1. Setting up the system: + = + . Make sure you have Chinese (Traditional, Taiwan) language pack install= ed on your Windows 7 machine. + Go to Control Panel->Clock, Language, and Region->Install or uninstall d= isplay languages->Install display languages->Launch Windows Updates (This i= s some screen shop in turn of what you can download http://windows7center.c= om/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 (T= raditional, Taiwan) + = + 3. Setup ij to displaye Chinese (Traditional, Taiwan) + = + . Please use the following option for org.apach.derby.tools.ij: -Dderby.= ui.locale=3Dzh_TW =E2=80=93Dderby.ui.codeset=3Dbig5 + = + 4. Setup derby server (database side) to display Chinese (Traditional, Ta= iwan) + = + . -Duser.language=3Dzh =E2=80=93Duser.country=3DTW + = + For example: + = + $ java -Duser.language=3Dzh -Duser.country=3DTW org.apache.derby.tools.ij= -p derby. + = + properties + = + ij =E7=89=88=E6=9C=AC 10.7 + = + ij> connect 'jdbc:derby:aa'; + = + =E9=8C=AF=E8=AA=A4 XJ004=EF=BC=9A=E6=89=BE=E4=B8=8D=E5=88=B0=E8=B3=87=E6= =96=99=E5=BA=AB 'aa'=E3=80=82 + = + ij> connect 'jdbc:derby:test_chinese;create=3Dtrue;user=3DREFRESH;passwor= d=3DRefresh'; + = + ij> select * from =E5=AE=B6=E9=95=B7; + = + =E9=8C=AF=E8=AA=A4 42Y07=EF=BC=9A=E7=B6=B1=E7=9B=AE 'REFRESH' =E4=B8=8D= =E5=AD=98=E5=9C=A8=E3=80=82 + = + ij> create table =E4=B8=AD=E6=96=87(stroke int, =E5=AD=97 varchar(4)); + = + =E5=B7=B2=E6=8F=92=E5=85=A5/=E6=9B=B4=E6=96=B0/=E5=88=AA=E9=99=A4 0 =E5= =88=97 + = + ij> insert into =E4=B8=AD=E6=96=87 values (1, '=E5=9C=8B'); + = + . =E5=B7=B2=E6=8F=92=E5=85=A5/=E6=9B=B4=E6=96=B0/=E5=88=AA=E9=99=A4 1 = =E5=88=97 + = + ij> insert into =E4=B8=AD=E6=96=87 values (2, '=E7=94=9F', '09-17-2010'); + = + =E9=8C=AF=E8=AA=A4 42802=EF=BC=9A=E6=8C=87=E6=B4=BE=E7=9A= =84=E5=80=BC=E6=95=B8=E7=9B=AE=E8=88=87=E6=8C=87=E5=AE=9A=E7=9A=84=E6=88=96= =E9=9A=B1=E5=90=AB=E7=9A=84=E7=9B=B4=E6=AC=84=E6=95=B8=E4=B8=8D=E7=9B=B8=E5= =90=8C + = + __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 i= n: + = + 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=3Dzh_CN =E2=80=93Dderby.ui.codeset=3DGB2312 + . + 4. Setup derby server (database side) to display Chinese (Traditional, Ta= iwan) + = + . Please use the following option: -Duser.language=3Dzh =E2=80=93Duser.c= ountry=3DTW + = + For example: + = + __$ java -Duser.language=3Dzh -Duser.country=3DCN org.apache.derby.tools.= ij -p derby.__ + = + __properties__ + = + __ij ____=E7=89=88=E6=9C=AC 10.7__ + = + ij> connect 'jdbc:derby:test_cn;create=3Dtrue;user=3DREFRESH;password=3DR= efresh'; + = + ij> values current_date; + = + 1 + = + ---------- + 2010-09-11 + = + =E5=B7=B2=E9=80=89=E6=8B=A9 1 =E8=A1=8C + = + ij> select * from aa; + = + =E9=94=99=E8=AF=AF 42Y07=EF=BC=9A=E6=A8=A1=E5=BC=8F=E2=80=9CREFRESH=E2=80= =9D=E4=B8=8D=E5=AD=98=E5=9C=A8=E3=80=82 + = + ij> create table =E7=99=BB=E5=BD=95 (=E8=BE=93=E5=85=A5 int, =E8=AE=B0=E5= =BD=95 varchar(4)); + = + =E5=B7=B2=E6=8F=92=E5=85=A5=EF=BC=8F=E6=9B=B4=E6=96=B0=EF=BC=8F=E5=88=A0= =E9=99=A4 0 =E8=A1=8C + = + ij> insert into =E7=99=BB=E5=BD=95 values (1, '=E5=8C=97=E4=BA=AC'); + = + =E5=B7=B2=E6=8F=92=E5=85=A5=EF=BC=8F=E6=9B=B4=E6=96=B0=EF=BC=8F=E5=88=A0= =E9=99=A4 1 =E8=A1=8C + = + ij> insert into =E7=99=BB=E5=BD=95 values (1, '=E9=87=8D=E5=BA=86', '=E5= =B9=BF=E5=B7=9E'); + = + =E9=94=99=E8=AF=AF 42802=EF=BC=9A=E5=B7=B2=E5=88=86=E9=85=8D=E5=80=BC=E7= =9A=84=E6=95=B0=E7=9B=AE=E4=B8=8E=E6=8C=87=E5=AE=9A=E5=88=97=E6=88=96=E6=9A= =97=E6=8C=87=E5=88=97=E7=9A=84=E6=95=B0=E7=9B=AE=E4=B8=8D=E5=90=8C=E3=80=82 + = + . + One can also use java program to look at the messages_zh_CN.properties. P= lease use =E2=80=93Dfile.encoding=3DCp939 for Chinese (Simplified, PRC ) an= d =E2=80=93Dfile.encoding=3DCp950 for Chinese(Traditional, Taiwan) +=20