Postgres Pro
Downloads
Home   >   mailing lists

get question mark with Chinese/Japanese character ? - Mailing list pgsql-jdbc

From Jiangyi
Subject get question mark with Chinese/Japanese character ?
Date
Msg-id CB5FFC93-A6FA-4D54-9F87-D7FF66181C64@sjtu.edu.cn
Whole thread Raw
Responses Re: get question mark with Chinese/Japanese character ?  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
Tree view
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

pgsql-jdbc by date:

Previous
From: Giuseppe Sacco
Date:
Subject: [PATCH] problem with DatabaseMetaData and mixed case table names
Next
From: Kris Jurka
Date:
Subject: Re: [PATCH] problem with DatabaseMetaData and mixed case