Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group