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

Re: JDBC CharSet with SQL_ASCII

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Mirco Attocchi <amirco(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: JDBC CharSet with SQL_ASCII
Date: 2010-01-14 09:51:47
Message-ID: 4B4EE933.4090706@opencloud.com (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-jdbc by date

Next:From: John T. DowDate: 2010-01-14 15:02:03
Subject: refreshRow is slow
Previous:From: Mirco AttocchiDate: 2010-01-14 08:38:30
Subject: JDBC CharSet with SQL_ASCII

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