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