Re: Accents bug ?

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 ...