Re: pgsql, java and accents

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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

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

In response to

Browse pgsql-general by date

  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)