From: Tatsuo Ishii <t-ishii@sra.co.jp>
To: Ashish Sharma <A.Sharma@toa.toasia.co.jp>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Japanese, Java and Postgres
Date: Tue, 16 Nov 1999 11:26:53 +0900
Message-ID: <199911160226.LAA01285@ext04.sra.co.jp> (raw)
In-Reply-To: <000901bf2f90$03e83950$a200a8c0@toasia.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
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: t-ishii@sra.co.jp, A.Sharma@toa.toasia.co.jp
Subject: Re: [INTERFACES] Japanese, Java and Postgres
In-Reply-To: <199911160226.LAA01285@ext04.sra.co.jp>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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