pg.ddx.io pgsql-interfaces@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Japanese, Java and Postgres 3+ messages / 2 participants [nested] [flat]
* Japanese, Java and Postgres @ 1999-11-15 17:36 Ashish Sharma <A.Sharma@toa.toasia.co.jp> 0 siblings, 1 reply; 3+ messages in thread From: Ashish Sharma @ 1999-11-15 17:36 UTC (permalink / raw) To: pgsql-interfaces; +Cc: t-ishii@sra.co.jp 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 And then I compiled the JDBC bridge. 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 !! -Ashish ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] Japanese, Java and Postgres @ 1999-11-16 02:26 Tatsuo Ishii <t-ishii@sra.co.jp> parent: Ashish Sharma <A.Sharma@toa.toasia.co.jp> 0 siblings, 1 reply; 3+ messages in thread From: Tatsuo Ishii @ 1999-11-16 02:26 UTC (permalink / raw) To: Ashish Sharma <A.Sharma@toa.toasia.co.jp>; +Cc: pgsql-interfaces > 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] Japanese, Java and Postgres @ 1999-11-17 07:52 Ashish Sharma <A.Sharma@toa.toasia.co.jp> parent: Tatsuo Ishii <t-ishii@sra.co.jp> 0 siblings, 0 replies; 3+ messages in thread From: Ashish Sharma @ 1999-11-17 07:52 UTC (permalink / raw) To: t-ishii@sra.co.jp; +Cc: pgsql-interfaces 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 > > ************ > > ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1999-11-17 07:52 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 1999-11-15 17:36 Japanese, Java and Postgres Ashish Sharma <A.Sharma@toa.toasia.co.jp> 1999-11-16 02:26 ` Tatsuo Ishii <t-ishii@sra.co.jp> 1999-11-17 07:52 ` Ashish Sharma <A.Sharma@toa.toasia.co.jp>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox