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
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 |