I can't insert the chinese words.

From: dauw <dauw(at)ms9(dot)url(dot)com(dot)tw>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: I can't insert the chinese words.
Date: 2003-02-18 09:25:07
Message-ID: 3E51FBF3.7030401@ms9.url.com.tw
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hello all,
I use the "(2003-02-09) JDBC3 JDK 1.4" JDBC driver to access the DB.
When I insert the chinese words (local= zh_TW ,"BIG5") into the varchar
column,it become "???".
But if I use the pgAdmin to do so ,It is success.

Then I select the ResultSet, The getString() mathod could not get the
correct words.
But if I use the sentence " String s =new String(rs.getBytes());" ,The
string s is correct.

I guess that is caused by char= 16-bit in java2.

Now how can I insert the chinese words (local= zh_TW ,"BIG5") into the
varchar column by jdbc?

regard

---------
OS: windows XP
JavaVM: j2sdk 1.4.1
JDBC :JDBC3
pssql:PostgreSQL 7.3.1

---Dauw
dauw(at)ms9(dot)url(dot)com(dot)tw

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2003-02-18 11:37:15 Re: ConnectionPool howto??
Previous Message Tom Lane 2003-02-18 03:41:55 Re: Leftover processes on shutdown - Debian+JDBC