Re: How to insert Chinese (big5) through JDBC?

On Wed, 30 Jul 2003, [big5] Eric Tan wrote:

> 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

You cannot store Big5 data in a SQL_ASCII encoded database.  Consider
using UNICODE.  Also the ?charset=xxx argument in the database URL is no
longer valid in the Postgresql JDBC drivers starting with 7.3.

Kris Jurka