[postgis-users] encoding question

[Markus Schaber]

Hi, Gilbert,

Gilbert, Antoine wrote:
> But why in the postgresql admin it show accent correctly ?

The JDBC driver always sets client_encoding to UTF-8, as Java uses
unicode internally. Now the PostgreSQL server cannot convert the
non-7-bit characters correctly to UTF-8, as there's no information how
to do it.

pgadmin seems to use the default database encoding, and then just
interpret 8-bit characters in the client-side locale encoding (which
seems to be non-utf8), so it looks working, although it is fragile.

Markus

-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org