Re: [INTERFACES] Japanese, Java and Postgres

> 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