At 20:09 01.10.01 -0400, you wrote:
Hello !
>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
Yes I read it, but it didn't help me much, I also tryed this :
postgres@sashimi:~$ psql -l ekai
List of databases
Database | Owner | Encoding
-----------+----------+-----------
ekai | postgres | UNICODE
template0 | postgres | SQL_ASCII
template1 | postgres | SQL_ASCII
(6 rows)
The problem is with database ekai... Accents, once again are ok in INSERT
but not in SELECT, and only with JDBC, not with psql (psql works perfectly).
Denis Bucher
NiftyCom
>-----Original Message-----
>From: pgsql-jdbc-owner@postgresql.org
>[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Denis Bucher
>Sent: October 1, 2001 4:42 PM
>To: PGSQL-JDBC
>Subject: [JDBC] Accents bug ?
...
>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 ...