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

Hi Kris Jurka,

When initializing the data, I can move the big5 data from MSSQL7 and insert into the postgresql database through VB. Why?

Another case: I write the insert statement to the debug file. I can read the Chinese there. If I copy and paste in "putty", I can also insert those Chinese correctly.

Thus, I guess the problem is inserting through JDBC.

Best Regards,
Eric Tan

Kris Jurka <books(at)ejurka(dot)com> wrote:

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('&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

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

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