Re: JDBC driver, PGSQL 7.3.2 and accents characters

Hi I've got the same problem, but my database is currently working, and
I'm wondering if there is way to change with an SQL command
like ALTER DATABASE ENCODING 'LATIN1' or somathing like that

thanks

-----Original Message-----
From: pgsql-jdbc-owner(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org]On Behalf Of Barry Lind
Sent: Wednesday, March 19, 2003 10:37 AM
To: Davide Romanini
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] JDBC driver, PGSQL 7.3.2 and accents characters

Davide,

Those characters are not part of the SQL_ASCII character set. SQL_ASCII

is 7bit ascii, the characters you are trying to use are all 8bit
characters. You need to create your database with a character set that
supports the characters you are trying to store. LATIN1 or UNICODE
would be good choices.

thanks,
--Barry

Davide Romanini wrote:
> Hi,
>
> I've nice problems with the jdbc driver. I've tried with the jdbc2,
> jdbc, latest stable and also development release.
> I've a database in postgres with some varchar fields. The database is
> SQL_ASCII as char encoding. In that varchar fields I've stored also
> names with accents such è, à, ì etc... They work fine using the psql
> program, and also linking tables to access through the odbc driver.
But
> when I try to use jdbc to connect to database my accents fail to load.

> For example I have the string 'Forlì Sud'. When I try to
> system.out.println this string catched by jdbc with rs.getString, I
see
> this string instead of the original one: 'Forl?ud'.
> I've tried also to use different character sets in the connection url
> like ISO-8859-1, UNICODE, WIN, SQL_ASCII but didn't change anything.
>
> Please help me, because this bug makes java and jdbc pretty unusable
to
> connect pgsql databases.
>
> Bye, Romaz
>
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org