From: | Fernando Lozano <fsl(at)centroin(dot)com(dot)br> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | redhat-list(at)redhat(dot)com, pgsql-general(at)postgresql(dot)org |
Subject: | Re: pgsql, java and accents |
Date: | 2002-01-31 01:39:57 |
Message-ID: | 3C58A06D.337D28D8@centroin.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi there!
Found the cause and I guess many people will be surprised. I found the
info on the JDBC 2.0 conformance tests at jdbc.postgresql.org.
It looks that recent versions of PostgreSQL, if compiled without
multi-byte characters suport (as are the RPM packages) will *allways*
respond to the JDBC driver it's working on US7_ASCII. That's why I could
not read nor write accents from Java, only from psql. Java was told to
use 7-but ASCII.
The workaround is described on the same doc: you have to append
"?charSet=ISO8859-1" to the connectionURL (or pass it as properties).
Actually the doc suggested UTF-8 but it didn't worked for me. ISO8859-1
worked fine.
Hope this helps other non-english speakers like me. :-)
[]s, Fernando Lozano
From | Date | Subject | |
---|---|---|---|
Next Message | Fernando Lozano | 2002-01-31 01:42:51 | Case-sentiveness on pgsql |
Previous Message | Marc Munro | 2002-01-31 00:55:06 | Row-based security (virtual private database) |