Re: JDBC and Accents

> 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