How to insert Chinese (big5) through JDBC?

From: Eric Tan <neltan2002(at)yahoo(dot)com(dot)hk>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: How to insert Chinese (big5) through JDBC?
Date: 2003-07-30 07:15:42
Message-ID: 20030730071542.99132.qmail@web13006.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi all,
I encounter problem when inserting Chinese.
These are my setting:
- postgresql 7.3 (database encoding: "SQL_ASCII")
- JDBC: pg73jdbc2.jar
- Tomcat 4.1.24
- JSP/Servlet/Java Bean
insert into table1 values('&curren;@&curren;G&curren;T') // chinese cannot display here...
Insert Chinese words are ok. But when I select the record, there were wrong sth. like '? ?&sup3;&aelig; '
The sql statement is in big5 format because I write it in a log file.
I've tried using charset like this. Not knowing why. All fail...
jdbc:postgresql://202.71.201.252:5432/CA_care?charSet=ISO-8859-1
jdbc:postgresql://202.71.201.252:5432/CA_care?charSet=SQL_ASCII
jdbc:postgresql://202.71.201.252:5432/CA_care?charSet=UTF-8
jdbc:postgresql://202.71.201.252:5432/CA_care?charSet=Big5

Any idea.
Best Regards,
Eric Tan

最新鈴聲推介:十面埋伏,多謝失戀,心淡...
http://ringtone.yahoo.com.hk

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Peter Eisentraut 2003-07-30 07:54:20 Re: [HACKERS] Passing server_encoding to the client is not future-proof
Previous Message Bruce Momjian 2003-07-30 02:20:16 Re: Very strange 'now' behaviour in nested triggers.