Thread: Is the JDBC driver i18n compatible?

I can't store/retrieve Chinese character in Postgresql thorough the JDBC. The problem seems to be in the version of
JDBC driver from the postgresql.org site. Do anyone know a i18n compatible postgresql JDBC driver some where? I
hate to see that I have to dump Postgresql only because the problem.

BTY, while looking for a Postgresql alternative, I learn the new release SAP DB, version 7.3, is double byte enable.
That is a greate news for folks who are working on Java multilingual application. I image people can store English,
Japanese, German in the same DB with a double byte enable DB.

Thanks Jochem for the information. The browsers I test on both IE and Opera. Chinese characters are displayed and
go thorough the a mail system correctly. Is something missing other than setting the right encoding in the DB?


9/26/2002 8:03:13 AM, Jochem van Dieten <jochemd@oli.tudelft.nl> wrote:

>Vernon Wu wrote:
>> I can't store/retrieve Chinese character in Postgresql thorough the JDBC. The problem seems to be in the version of
>> JDBC driver from the postgresql.org site. Do anyone know a i18n compatible postgresql JDBC driver some where? I
>> hate to see that I have to dump Postgresql only because the problem.
>
>http://130.161.67.253:8500/www/ runs on PostgreSQL and the stock JDBC
>driver and I haven't been able to break it yet. Not even with Macedonian
>or one of the other more esoteric charsets. So if your problem is still
>about the web application, I think you should take a good look at what
>you use for frontend.
>
>Jochem
>
>

Also, the site is built with coldFusion, not Java. The problem I complain is the JDBC, not the Postgresl itself.


9/26/2002 8:03:13 AM, Jochem van Dieten <jochemd@oli.tudelft.nl> wrote:

>Vernon Wu wrote:
>> I can't store/retrieve Chinese character in Postgresql thorough the JDBC. The problem seems to be in the version of
>> JDBC driver from the postgresql.org site. Do anyone know a i18n compatible postgresql JDBC driver some where? I
>> hate to see that I have to dump Postgresql only because the problem.
>
>http://130.161.67.253:8500/www/ runs on PostgreSQL and the stock JDBC
>driver and I haven't been able to break it yet. Not even with Macedonian
>or one of the other more esoteric charsets. So if your problem is still
>about the web application, I think you should take a good look at what
>you use for frontend.
>
>Jochem
>
>

Vernon,

Yes the jdbc driver is i18n compatible.  May users run with unicode and
other character sets.  What verson of the postgres server are you
running?  Did you build postgres with multibyte support enabled? Did you
create your database in the correct character set?

thanks,
--Barry


Vernon Wu wrote:
 > I can't store/retrieve Chinese character in Postgresql thorough the
JDBC. The problem seems to be in the version of
 > JDBC driver from the postgresql.org site. Do anyone know a i18n
compatible postgresql JDBC driver some where? I
 > hate to see that I have to dump Postgresql only because the problem.
 >
 > BTY, while looking for a Postgresql alternative, I learn the new
release SAP DB, version 7.3, is double byte enable.
 > That is a greate news for folks who are working on Java multilingual
application. I image people can store English,
 > Japanese, German in the same DB with a double byte enable DB.
 >
 >
 >
 > ---------------------------(end of broadcast)---------------------------
 > TIP 4: Don't 'kill -9' the postmaster
 >