Can I insert Big5 Chinese from Java servlet(Tomcat) to PostgreSQL 7.3

From: ¾GÁn©M <sean(at)lager(dot)com(dot)tw>
To: pgsql-general(at)postgresql(dot)org
Subject: Can I insert Big5 Chinese from Java servlet(Tomcat) to PostgreSQL 7.3
Date: 2003-02-11 12:02:29
Message-ID: 3E48E655.1408C7C1@lager.com.tw
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

We are current using PostgreSQL 7.2. When we tried to upgrade to
PostgreSQL 7.3, there is a problrm in insert Chinese into database.

In PostgreSQL 7.2, we didn't enable the multibyte support. When we
created database, we used SQL_ASCII encoding. It worked fine with Tomcat
and Java servlet and can access Big5 code without problem. But in
PostgreSQL 7.3, if we created databse with SQL_ASCII or UNICODE
encoding, our data converted to Unicode automaticly. If we created
database with EUC_TW, our data converted to euc_tw.

Since we have another system, which is written by C, access the same
database. We'd like to continue accessing our database using Big5
encoding. Is there any option to do that? Can we disable the multibyte
support in PostgreSQL 7.3 just like PostgreSQL 7.2?

We are using : Linux 2.4.18, JDK 1.3.1, Tomcat 3.2.3, PostgreSQL 7.3

Thanks in advance.

Sheng-Ho Cheng.

Browse pgsql-general by date

  From Date Subject
Next Message Marcelo Pereira 2003-02-11 12:36:46 Re: PostgreSQL x Oracle
Previous Message Colin Mangiagalli 2003-02-11 11:57:27 Writes to transaction logs, Permission Denied