Received: from toa.toasia.co.jp ([210.227.134.242]) by hub.org (8.9.3/8.9.3) with ESMTP id CAA84497 for ; Wed, 17 Nov 1999 02:55:21 -0500 (EST) (envelope-from A.Sharma@toa.toasia.co.jp) Received: from delhi ([210.227.134.250]) by toa.toasia.co.jp (8.9.1b+Sun/8.9.1) with SMTP id QAA11507; Wed, 17 Nov 1999 16:49:24 +0900 (JST) Message-ID: <000b01bf30d0$c3b0add0$a200a8c0@toasia.co.jp> From: "Ashish Sharma" To: Cc: References: <199911160226.LAA01285@ext04.sra.co.jp> Subject: Re: [INTERFACES] Japanese, Java and Postgres Date: Wed, 17 Nov 1999 16:52:57 +0900 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-2022-jp" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 Thank u Ishii-san, it worked !! > > I have a Java applet (1.1.5) running on win9x/IE/Netscape, > > using which the user can enter Japanese charactors. > > > > On the backend (RedHat 5.2 Japanese), I just installed postgresql 6.5 with > > > > ./configure --enable-locale --with-mb=UNICODE --with-odbc > > I assume you are going to use English and Japanese only. > In this case I would recommend: > > ./configure --with-mb=EUC_JP --with-odbc > > > And then I compiled the JDBC bridge. > ~~~~~~~~~~~ > Isn't this JDBC driver, right? > > > Now, when I insert some Japanese charactors in the DB and select it back, > > I get ??? marks. > > > > What I'm missing?? I'm not doing any encoding stuff programmatically... > > > > Please help me, and don't force me to go back to SQL Server !! > > The JDBC driver coming with PostgreSQL does not understand what > encoding is used in database. So you should explicitly tell it that > you want to use Japanese. You need set the user.language property to > "ja" and the file.encoding property to "EUCJIS". For a stand alone Java > application you could do that: > > $ java -Duser.language=ja -Dfile.encoding=EUCJIS Your_class_name > > I recommend you try with a stand alone Java application first. Applets > sometimes make things more difficult because of JVM problems etc. > --- > Tatsuo Ishii > > ************ > >