iso-8859-1 characters in psql

From: "Mig-O" <eindummeadresse(at)Mig-O(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: iso-8859-1 characters in psql
Date: 2003-03-26 14:17:12
Message-ID: b5scon$n21$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I want to have iso-8859-1 characters to be displayed in psql.

I am using Linux with german umlauts enabled, meaning my console is set to
iso8859-1 and readline accepts ,,, etc. My Database encoding is UNICODE.
The inserting of umlauts works, and there are umlauts in the database
tables.

When i use client_encoding=UNICODE, "select * from kunden where ...foo...."
returns "tst" instead of "tst", so it seems like a dump of the internal
utf-8 encoding. It is OK, because of course my linux console is using
iso8859-1 and not unicode, like stated in the variable, but okay...

When i use client_encoding=iso-8859-1, "select * from kunden where
...foo...." returns "tst" instead of "tst", so it seems hat the characters
get dropped instead of beeing converted.

Is it possible to have psql behaving correctly?
Or would it normally behave correctly, and i have another problem with my
system, like some locale configuration error?

cheers and thanx,
Mig-O

Browse pgsql-general by date

  From Date Subject
Next Message Chris Smith 2003-03-26 15:16:24 Please help with this error message
Previous Message Csaba Nagy 2003-03-26 11:30:46 Re: transaction blocking inserts in postgresql 7.3