Re: JDBC and Accents - Mailing list pgsql-general

From Loïc Courtois
Subject Re: JDBC and Accents
Date
Msg-id 00e501c0cf16$aa7ca720$7501a8c0@JADE
Whole thread Raw
In response to JDBC and Accents  (Loïc Courtois <lcourtois@netpartage.fr>)
Responses Re: JDBC and Accents
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...

My database encoding is SQL_ASCII...

Is there any temporary solutions, or may a convert the db in an other
encoding?

Thanks

Loic Courtois



pgsql-general by date:

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