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

Re: JDBC and Accents

From: Loïc Courtois <lcourtois(at)netpartage(dot)fr>
To: "Marko Kreen" <marko(at)l-t(dot)ee>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: JDBC and Accents
Date: 2001-04-27 12:36:21
Message-ID: 00e501c0cf16$aa7ca720$7501a8c0@JADE (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-jdbc
> 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



In response to

Responses

pgsql-jdbc by date

Next:From: Tony GrantDate: 2001-04-27 12:37:48
Subject: Re: JDBC and Accents
Previous:From: Peter T MountDate: 2001-04-27 12:32:24
Subject: Re: [ROWSET]

pgsql-general by date

Next:From: Tony GrantDate: 2001-04-27 12:37:48
Subject: Re: JDBC and Accents
Previous:From: Marko KreenDate: 2001-04-27 12:26:14
Subject: Re: JDBC and Accents

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