Re: JDBC and Accents - Mailing list pgsql-general

From Marko Kreen
Subject Re: JDBC and Accents
Date
Msg-id 20010427142614.A28684@l-t.ee
Whole thread Raw
In response to JDBC and Accents  (Loïc Courtois <lcourtois@netpartage.fr>)
Responses Re: JDBC and Accents
List pgsql-general
On Fri, Apr 27, 2001 at 01:56:38AM +0200, Loïc Courtois wrote:
> Hello,
>
> I have some problems to display the accents in my db, using the JDBC and
> postgres 7.1.
>
> Apparently, all accents are replaced by a '?'.

What is your database encoding?

You can insert whatever stuff you want into db and
psql displays it fine - it does not care what it is.

But JDBC 7.1 does use database encoding for understanding
stuff it gets and translating it to Java strings.  So if your
db encoding is SQL_ASCII but data is LATIN1 you are screwed.
Same with data in LATIN1 and db in UNICODE.  etc...

--
marko


pgsql-general by date:

Previous
From: Tony Grant
Date:
Subject: Re: JDBC and Accents
Next
From: Tony Grant
Date:
Subject: Re: JDBC and Accents