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

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

>-----Original Message-----
>[mailto:[EMAIL PROTECTED]] On Behalf Of Denis Bucher
>Sent: October 1, 2001 4:42 PM
>Subject: [JDBC] Accents bug ?


>When INSERTing a value like "Genève" it works, but when doing a SELECT
>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 ...

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to