How to insert Chinese (big5) through JDBC? - Mailing list pgsql-jdbc

From Eric Tan
Subject How to insert Chinese (big5) through JDBC?
Date
Msg-id 20030730071542.99132.qmail@web13006.mail.yahoo.com
Whole thread Raw
Responses Re: How to insert Chinese (big5) through JDBC?
List 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('¤@¤G¤T') // chinese cannot display here...
   Insert Chinese words are ok. But when I select the record, there were wrong sth. like '? ?³æ '
   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

pgsql-jdbc by date:

Previous
From: Nic
Date:
Subject: JDBC stored procs doc patch
Next
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] Passing server_encoding to the client is not future-proof