Re: JDBC CharSet with SQL_ASCII - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: JDBC CharSet with SQL_ASCII
Date
Msg-id 4B4EE933.4090706@opencloud.com
Whole thread Raw
In response to JDBC CharSet with SQL_ASCII  (Mirco Attocchi <amirco@gmail.com>)
List pgsql-jdbc
Mirco Attocchi wrote:
> Hi All,
> I'm newest to this list (sorry for my bad english).
> I've a question about charset with jdbc.
> I've verified that my customer postgresql database is configured in
> SQL_ASCII but when I read data I receive strange chars in some fields.
>
> Do you know how I can determinate the right character set?

Well, the problem with SQL_ASCII is exactly that - there is no
information about what encoding should be used to interpret the data.
You will have to inspect the data stored in the database by hand and
work out what encoding it is actually using. Then you should probably
convert the database to use UNICODE or another appropriate encoding.

-O

pgsql-jdbc by date:

Previous
From: Mirco Attocchi
Date:
Subject: JDBC CharSet with SQL_ASCII
Next
From: "John T. Dow"
Date:
Subject: refreshRow is slow