Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 49474 invoked from network); 6 Aug 2010 04:38:20 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 6 Aug 2010 04:38:20 -0000 Received: (qmail 28829 invoked by uid 500); 6 Aug 2010 04:38:20 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 28634 invoked by uid 500); 6 Aug 2010 04:38:18 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 28627 invoked by uid 99); 6 Aug 2010 04:38:17 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 06 Aug 2010 04:38:17 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [74.6.228.93] (HELO n13.bullet.mail.ac4.yahoo.com) (74.6.228.93) by apache.org (qpsmtpd/0.29) with SMTP; Fri, 06 Aug 2010 04:38:07 +0000 Received: from [76.13.12.67] by n13.bullet.mail.ac4.yahoo.com with NNFMP; 06 Aug 2010 04:37:46 -0000 Received: from [76.13.10.167] by t8.bullet.mail.ac4.yahoo.com with NNFMP; 06 Aug 2010 04:37:45 -0000 Received: from [127.0.0.1] by omp108.mail.ac4.yahoo.com with NNFMP; 06 Aug 2010 04:37:45 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 883955.75954.bm@omp108.mail.ac4.yahoo.com Received: (qmail 40278 invoked by uid 60001); 6 Aug 2010 04:37:45 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1281069465; bh=lgcvar1mnA4D8tCCedjGWJyNv07YvCduRyOWVFlLc6w=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=FWW5oIWMfiEpXEtGqtDSopUdjR3gHRnHgKPrXeOvdo+WSACDXmFRvGsdgl0/CRqW2eRhhdx56H+Cpfm8piiXFpxKfx9ntJUY5zTFrMVrC82nYkvCfo/GKize9TAGgWN3dESAKWhxnKg8y0DXyxLt9VORF5iLrB02lEpwLqy3aIU= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=aD0g1pzpfwGyhvnbZYjVknxx/hkjYpo3sflznuVTSJFtAEs2Ief9BjfT3LHtM3q2tSfWeg8fgUrfPnvje6pxo4C0VjohSPk2aCyMvEmKbP0Iu2zEWHU9BSlJyeZwBEa2Rtt+zDP9Fy8i5f2DGZ37OoKYzHY68tPOpKfJL5HyAtI=; Message-ID: <555818.40112.qm@web65710.mail.ac4.yahoo.com> X-YMail-OSG: GVZj6KcVM1kE87q_ZWBbGd1sIgOiXdRvFGpjyFGuYsgh2Q9 B6wC44hyT3eCmCJ9yWp5xeOufqWDGAHaJGkr5TiAKas1UL2ENCMwiqcIgEuQ Uq.HNvrYeu8VXd.fQ.eN27Bzt20s45uWJYxQ8LwLk6bximF9_lvZlBlIdHqW U4B4fWOWeHpBqTIBTV8spodpmxpz48u0pd7U5iX9ocAUHjgLoSxsG.UoFegJ vqI.kqwHOPPPIfFcq2g7jgtNmjbllEnQiWK21vBZIms3VCoD6xogGYU2MCWL n74.tce9GkbWy2RcpH8Aujgj0MoN65M0xSgSO48DOARQfCQR5FSFmNt5smTV yzsbDtHynUMmluw-- Received: from [76.126.225.38] by web65710.mail.ac4.yahoo.com via HTTP; Thu, 05 Aug 2010 21:37:45 PDT X-Mailer: YahooMailRC/459 YahooMailWebService/0.8.105.279950 References: <4C583862.5060704@oracle.com> <7734.3285.qm@web65704.mail.ac4.yahoo.com> <20100804072238.GA13734@humalog.norway.sun.com> Date: Thu, 5 Aug 2010 21:37:45 -0700 (PDT) From: Lily Wei Subject: Re: 10.6 message localizations To: derby-dev@db.apache.org In-Reply-To: <20100804072238.GA13734@humalog.norway.sun.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="0-1908545811-1281069465=:40112" X-Virus-Checked: Checked by ClamAV on apache.org --0-1908545811-1281069465=:40112 Content-Type: multipart/alternative; boundary="0-404028860-1281069465=:40112" --0-404028860-1281069465=:40112 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hi Kristian:=0A Thank you for the detail information.=0AI am still not g= etting ij to display chinese charater. =0AFrom your output, you are display= ing Simplified Chinese. =0A=E7=89=88=E6=9C=AC is Version. And, it is the sa= me for Simplified and Complicated.=0A=E9=80=89=E6=8B=A9 is "set" and this i= s Simplified character. =E9=81=B8=E6=93=87 is complicated character.=0A=0A = I am not sure what jar file $JDB_10610 point to.=0AI set my derby.propert= ies file with:=0Aderby.ui.territory=3Dzh_CN=0Aderby.ui.locale=3Dzh_CN=0A#de= rby.ui.codeset=3DGB2312=0Aderby.ui.codeset=3DUTF8 =0A And, I did not get= =E7=89=88=E6=9C=AC, but =E2=96=91=C2=B5=E2=96=92=E2=95=9B=0A=0A When ru= nning java DisplayLocalization, I got:=0A$ java DisplayLocalization =0A/c/d= erby/trunk/java/engine/org/apache/derby/loc/messag=0Aes_zh_CN.properties 42= XAH 42Z10 I028=0A42XAH=3DNEXT VALUE FOR ??????????????????? WHERE?ON?HAVING= ?ORDER =0ABY?DISTINCT?CASE?GENERATION ? AGGREGA=0ATE ???? WINDOW ??? CHECK = ???=0A42Z10=3D??????????? Java ????? Derby ????????''{0}''?=0AI028=3D??????= ???????????????????=0A=0A After some research, I use swingsample from = =0Ahttp://www.chinesecomputing.com/programming/java.html.=0AI am hoping to = display chinese character using swing by executing 'java =0Aswingsample =0A= /c/derby/trunk/java/engine/org/apache/derby/loc/messages_zh_CN.properties'.= I =0Acould only display the original zh_CN message file.=0AWill it be some= sort of font or resource file that I need for my system?=0A=0A Thanks R= ick for point out using zh_CN for locale info.=0A=0A=0ABest Regards,=0ALily= =0A=0A =0A=0A =0A=0A$ LANG=3Dzh.UTF-8 ij -p derby.properties=0Aij =E2= =96=91=C2=B5=E2=96=92=E2=95=9B 10.7=0A=0A =0A=0A=0AHi Lily,=0A=0AI find= using locales a bit confusing too, and tried to find a=0Adescription in ou= r manuals. My very brief search took me to "About=0Alocales" in the Derby T= ools and Utilities Guide.=0A=0ANow, here's what I did to get Chinese charac= ters:=0A(they look Chinese to me when writing this mail, I have no idea if= =0Acopy and paste will work as expected...)=0A=0A$ LANG=3Dzh.UTF-8 java -cp= $JDB_10610 org.apache.derby.tools.ij=0Aij =E7=89=88=E6=9C=AC 10.6=0Aij> co= nnect 'jdbc:derby:memory:testdb;create=3Dtrue';=0Aij> values current_date;= =0A1 =0A----------=0A2010-08-04=0A=0A=E5=B7=B2=E9=80=89=E6=8B=A9 1 = =E8=A1=8C=0Aij> localizeddisplay on;=0Aij> values current_date;=0A1 = =0A-----------=0A2010=E5=B9=B48=E6=9C=884=E6=97=A5 =0A=0A=E5=B7=B2=E9=80= =89=E6=8B=A9 1 =E8=A1=8C=0Aij>=0A=0AIt is unclear to me which of the zh loc= alizations is used in this case.=0AMaybe there are rules determining that, = or maybe you must/can specify=0Aderby.ui.locale?=0A=0A=0ANow, I'm at a loss= for how to display the localized messages easily. I=0Aended up writing a s= mall Java code snippet (see the attached=0ADisplayLocalization.java).=0AHop= efully people will let us know if there is a simpler way :)=0A=0A=0AHope th= is helps,=0A-- =0AKristian=0A=0A> =0A> Is the characters for current_date= a valid display value for zh_CH locale?=0A> =0A> =0A> Thanks,=0A> Lily=0A>= =0A> =0A> =0A> =0A=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81= =E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2= =94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94= =81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81= =E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2= =94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94= =81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81= =E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2= =94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94= =81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=0A> From: Rick Hi= llegas =0A> To: "derby-dev@db.apache.org" =0A> Sent: Tue, August 3, 2010 8:40:18 AM=0A> Subject: 10= .6 message localizations=0A> =0A> Two weeks ago I posted localizations of t= he 10.6 message changes (see https://=0A> issues.apache.org/jira/browse/DER= BY-4666 ). These are translations for the=0A> following languages:=0A> =0A>= Chinese (simplified)=0A> Chinese (traditional)=0A> French=0A> German=0A> I= talian=0A> Japanese=0A> Korean=0A> Spanish=0A> =0A> So far, Knut has verifi= ed that the 10.6 localizations don't suffer from the=0A> problems which pla= gued the 10.4 and 10.5 translations. But this slug of =0Achanges=0A> might = suffer from other problems. If you are an expert in one of the languages=0A= > listed above, your review would be helpful. I intend to commit these chan= ges=0A> next week unless community review discloses a real howler. Of cours= e, the=0A> localizations can always be improved incrementally after that.= =0A> =0A> Reviewing these changes should be easy. The changes.html attachme= nt gives you=0A> the English text of the new and changed messages. You just= need to confirm =0Athat=0A> the patch reflects those changes for the langu= ages you know.=0A> =0A> Thanks for your help,=0A> -Rick=0A> =0A=0A=0A=0A = --0-404028860-1281069465=:40112 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Hi Kristian:
    Thank you for the detail information.=
I am still not getting ij to display chinese charater.
From your ou= tput, you are displaying Simplified Chinese.
=E7=89=88=E6=9C=AC is Vers= ion. And, it is the same for Simplified and Complicated.
=E9=80=89=E6=8B= =A9 is "set" and this is Simplified character. <= meta name=3D"Originator" content=3D"Microsoft Word 12">=E9=81=B8=E6=93=87 is complicated = character.

   I am not sure what jar file $JDB_10610 point= to.
I set my derby.properties file with:
derby.ui.territory=3Dzh_CN<= br>derby.ui.locale=3Dzh_CN
#derby.ui.codeset=3DGB2312
derby.ui.codese= t=3DUTF8
    And, I did not get =E7=89=88=E6=9C=AC, but = =E2=96=91=C2=B5=E2=96=92=E2=95=9B

    When running ja= va DisplayLocalization, I got:
$ java DisplayLocalization /c/derby/trunk= /java/engine/org/apache/derby/loc/messag
es_zh_CN.properties 42XAH 42Z10= I028
42XAH=3DNEXT VALUE FOR ??????????????????? WHERE?ON?HAVING?ORDER B= Y?DISTINCT?CASE?GENERATION ? AGGREGA
TE ???? WINDOW ??? CHECK ???
42Z= 10=3D??????????? Java ????? Derby ????????''{0}''?
I028=3D??????????????= ???????????

    After some research, I use swin= gsample from http://www.= chinesecomputing.com/programming/java.html.
I am hoping to di= splay chinese character using swing by executing 'java swingsample /c/derby= /trunk/java/engine/org/apache/derby/loc/messages_zh_CN.properties'. I could= only display the original zh_CN message file.
Will it be some sort of f= ont or resource file that I need for my system?

    T= hanks Rick for point out using zh_CN for locale info.


Best Regar= ds,
Lily

   

  

$ LANG=3Dzh.U= TF-8 ij -p derby.properties
ij =E2=96=91=C2=B5=E2=96=92=E2=95=9B 10.7
    

Hi Lily,

I find using locales a = bit confusing too, and tried to find a
description in our manuals. My ve= ry brief search took me to "About
locales" in the Derby Tools and Utilit= ies Guide.

Now, here's what I did to get Chinese characters:
(they l= ook Chinese to me when writing this mail, I have no idea if
copy and pas= te will work as expected...)

$ LANG=3Dzh.UTF-8 java -cp $JDB_10610 o= rg.apache.derby.tools.ij
ij =E7=89=88=E6=9C=AC 10.6
ij> connect 'j= dbc:derby:memory:testdb;create=3Dtrue';
ij> values current_date;
1=        
----------
2010-08-04

=E5=B7=B2= =E9=80=89=E6=8B=A9 1 =E8=A1=8C
ij> localizeddisplay on;
ij> val= ues current_date;
1         
-----------2010=E5=B9=B48=E6=9C=884=E6=97=A5 

=E5=B7=B2=E9=80=89=E6=8B= =A9 1 =E8=A1=8C
ij>

It is unclear to me which of the zh locali= zations is used in this case.
Maybe there are rules determining that, or= maybe you must/can specify
derby.ui.locale?


Now, I'm at a lo= ss for how to display the localized messages easily. I
ended up writing = a small Java code snippet (see the attached
DisplayLocalization.java).
Hopefully people will let us kno= w if there is a simpler way :)


Hope this helps,
--
Kristi= an

>
>  Is the characters for current_date a valid d= isplay value for zh_CH locale?
>
>
> Thanks,
> Li= ly
>
>
>
> =E2=94=81=E2=94=81=E2=94=81=E2=94=81= =E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2= =94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94= =81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81= =E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2= =94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94= =81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81= =E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2= =94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94= =81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=E2=94=81=
> From: Rick Hillegas <rick.hillegas@oracle.com&= gt;
> To: "derby-dev@db.apache.org" <derby-dev@db.apache.org>> Sent: Tue, August 3, 2010 8:40:18 AM
> Subject: 10.6 message lo= calizations
>
> Two weeks ago I posted localizations of the 10= .6 message changes (see https://
> issues.apache.org/jira/browse/D= ERBY-4666 ). These are translations for the
> following languages= :
>
> Chinese (simplified)
> Chinese (traditional)
&g= t; French
> German
> Italian
> Japanese
> Korean> Spanish
>
> So far, Knut has verified that the 10.6 loca= lizations don't suffer from the
> problems which plagued the 10.4 and= 10.5 translations. But this slug of changes
> might suffer from othe= r problems. If you are an expert in one of the languages
> listed abo= ve, your review would be helpful. I intend to commit these changes
> next week unless community review discloses a real howler. Of course, the<= br>> localizations can always be improved incrementally after that.
&= gt;
> Reviewing these changes should be easy. The changes.html attac= hment gives you
> the English text of the new and changed messages. Y= ou just need to confirm that
> the patch reflects those changes for t= he languages you know.
>
> Thanks for your help,
> -Rick=
>
=0A

=0A=0A=0A=0A=0A=0A=0A=0A --0-404028860-1281069465=:40112-- --0-1908545811-1281069465=:40112 Content-Type: text/plain; name="swingsample.java" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="swingsample.java" aW1wb3J0IGphdmEubGFuZy4qOw0KaW1wb3J0IGphdmEuaW8uKjsNCmltcG9y dCBqYXZhLmF3dC4qOw0KaW1wb3J0IGphdmEuYXd0LmV2ZW50Lio7DQppbXBv cnQgamF2YS51dGlsLio7DQoNCmltcG9ydCBqYXZheC5zd2luZy4qOw0KDQpw dWJsaWMgY2xhc3Mgc3dpbmdzYW1wbGUgZXh0ZW5kcyBKRnJhbWUgew0KICAg IHByaXZhdGUgc3RhdGljIEpUZXh0QXJlYSBtVGV4dEFyZWE7DQoNCiAgICBw dWJsaWMgc3dpbmdzYW1wbGUoU3RyaW5nIGZpbGVuYW1lKSB7DQoJc3VwZXIo IkdCIEZpbGUgVmlld2VyIik7DQoJY3JlYXRlVUkoKTsNCgl0cnkgew0KCSAg ICBsb2FkZmlsZShmaWxlbmFtZSwgIkdCMjMxMiIpOyAgLy8gb3IgIkJJRzUi DQoJfSANCgljYXRjaCAoRXhjZXB0aW9uIGxvYWRleGMpIHsNCgl9DQoJc2V0 VmlzaWJsZSh0cnVlKTsNCiAgICB9DQoNCiAgICBwdWJsaWMgc3RhdGljIHZv aWQgbG9hZGZpbGUoU3RyaW5nIGZpbGVuYW1lLCBTdHJpbmcgZW5jKQ0KCXRo cm93cyBJT0V4Y2VwdGlvbiwgVW5zdXBwb3J0ZWRFbmNvZGluZ0V4Y2VwdGlv bg0KICAgIHsNCglTdHJpbmcgbmV3bGluZTsNCglTdHJpbmcgYnVmZmVyOw0K CUlucHV0U3RyZWFtIGluOw0KCQ0KCW5ld2xpbmUgPSBTeXN0ZW0uZ2V0UHJv cGVydHkoImxpbmUuc2VwYXJhdG9yIik7DQoJDQoJaW4gPSBuZXcgRmlsZUlu cHV0U3RyZWFtKGZpbGVuYW1lKTsNCgkvLyBTZXQgdXAgY2hhcmFjdGVyIHN0 cmVhbQ0KCUJ1ZmZlcmVkUmVhZGVyIHIgPSBuZXcgQnVmZmVyZWRSZWFkZXIo bmV3IElucHV0U3RyZWFtUmVhZGVyKGluLCBlbmMpKTsNCgl3aGlsZSAoKGJ1 ZmZlciA9IHIucmVhZExpbmUoKSkgIT0gbnVsbCkgew0KCSAgICBtVGV4dEFy ZWEuYXBwZW5kKGJ1ZmZlciArIG5ld2xpbmUpOw0KCX0NCglyLmNsb3NlKCk7 DQogICAgfQ0KDQogICAgcHJvdGVjdGVkIHZvaWQgY3JlYXRlVUkoKSB7DQoJ c2V0U2l6ZSg1MDAsIDUwMCk7DQoJQ29udGFpbmVyIGNvbnRlbnQgPSBnZXRD b250ZW50UGFuZSgpOw0KCWNvbnRlbnQuc2V0TGF5b3V0KG5ldyBCb3JkZXJM YXlvdXQoKSk7DQoJDQoJbVRleHRBcmVhID0gbmV3IEpUZXh0QXJlYSgpOw0K CS8vbVRleHRBcmVhLnNldEZvbnQobmV3IEZvbnQoIkJpdHN0cmVhbSBDeWJl cmJpdCIsIEZvbnQuUExBSU4sIDEyKSk7DQoJSlNjcm9sbFBhbmUgc2Nyb2xs UGFuZSA9IG5ldyBKU2Nyb2xsUGFuZShtVGV4dEFyZWEsDQoJCQkJCQkgSlNj cm9sbFBhbmUuVkVSVElDQUxfU0NST0xMQkFSX0FMV0FZUywNCgkJCQkJCSBK U2Nyb2xsUGFuZS5IT1JJWk9OVEFMX1NDUk9MTEJBUl9BTFdBWVMpOw0KCWNv bnRlbnQuYWRkKHNjcm9sbFBhbmUsIEJvcmRlckxheW91dC5DRU5URVIpOw0K CQ0KCS8vIEV4aXQgdGhlIGFwcGxpY2F0aW9uIHdoZW4gdGhlIHdpbmRvdyBp cyBjbG9zZWQuDQoJYWRkV2luZG93TGlzdGVuZXIobmV3IFdpbmRvd0FkYXB0 ZXIoKSB7DQoJICAgIHB1YmxpYyB2b2lkIHdpbmRvd0Nsb3NpbmcoV2luZG93 RXZlbnQgZSkgew0KCQlTeXN0ZW0uZXhpdCgwKTsNCgkgICAgfQ0KCX0pOw0K ICAgIH0NCg0KICAgIHB1YmxpYyBzdGF0aWMgdm9pZCBtYWluKFN0cmluZ1td IGFyZ3MpIHsNCgluZXcgc3dpbmdzYW1wbGUoYXJnc1swXSk7DQogICAgfQ0K ICAgIA0KfSAvLyBzd2luZ3NhbXBsZQ0K --0-1908545811-1281069465=:40112--