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('¤@¤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
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. |