Re: JDBC and Accents

From: Marko Kreen <marko(at)l-t(dot)ee>
To: Loïc Courtois <lcourtois(at)netpartage(dot)fr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: JDBC and Accents
Date: 2001-04-27 13:32:45
Message-ID: 20010427153245.B30250@l-t.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

On Fri, Apr 27, 2001 at 02:36:21PM +0200, Loïc Courtois wrote:
> > 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.

> My database encoding is SQL_ASCII...
>
> Is there any temporary solutions, or may a convert the db in an other
> encoding?

Correct solutions is really dump database, create db with right
encoding and restore.

But for temporary solution ;) you could use PostgreSQL 7.0
JDBC driver, which does not support those db encodings...

--
marko

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter T Mount 2001-04-27 13:45:06 Re: JDBC and Accents
Previous Message Marko Kreen 2001-04-27 13:24:59 Re: JDBC and Accents

Browse pgsql-jdbc by date

  From Date Subject
Next Message Peter T Mount 2001-04-27 13:45:06 Re: JDBC and Accents
Previous Message Marko Kreen 2001-04-27 13:24:59 Re: JDBC and Accents