Re: Accents bug ?

Denis,

It sounds like an encoding problem. You can check the encoding of the db
by using \encoding in psql.

There is a section in the docs on this
http://www.postgresql.org/idocs/index.php?multibyte.html

Dave

-----Original Message-----
From: pgsql-jdbc-owner(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of Denis Bucher
Sent: October 1, 2001 4:42 PM
To: PGSQL-JDBC
Subject: [JDBC] Accents bug ?

Hello !

BIG problem ;-)

When INSERTing a value like "Genève" it works, but when doing a SELECT
the
fields
are troncated when containing acents :

"Genève" is received as "Gen"
"Thé froid" as "Th"
"Hosomaki végétarien" as "Hosomaki v"
and so on ...

Does someone knows if it is a but in the driver or another problem ?

Thanks alot in advance for any help :-)

Denis Bucher
NiftyCom

P.S. Using latest version of JDBC, Java and postgresql 7.1

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org