get question mark with Chinese/Japanese character ?

From: Jiangyi <jiangyi(at)sjtu(dot)edu(dot)cn>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: get question mark with Chinese/Japanese character ?
Date: 2005-08-08 11:59:25
Message-ID: CB5FFC93-A6FA-4D54-9F87-D7FF66181C64@sjtu.edu.cn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hello everyone
I am now using Jdbc driver(pg74.216.jdbc3.jar) with Postgresql
7.4.7 on macosx 10.4.2 .
I have a question about the character encoding.
I have a program that write data into database. When I change
the system
language to English, the chinese and japanese character data
inserted into
the table will be garabed character. When I change the system
language to
Chinese or japanese, the data inserted into postgresql database are
all right.
I have already set the database encoding into UNICODE.
How can I to let my program always insert the correct data into
database
regardless the operating system language settings.

Name | Owner | Encoding
---------------+----------+---------------
licsrv | jiang | UNICODE
template0 | postgres | SQL_ASCII
template1 | postgres | SQL_ASCII

Regards
Jiang
cucmi(at)163(dot)com

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Giuseppe Sacco 2005-08-08 16:20:43 [PATCH] problem with DatabaseMetaData and mixed case table names
Previous Message Oliver Jowett 2005-08-07 22:04:34 Re: getIndexInfo() is not returning filter condition.