iso-8859-1 characters in psql
| От | Mig-O |
|---|---|
| Тема | iso-8859-1 characters in psql |
| Дата | |
| Msg-id | b5scon$n21$1@news.hub.org обсуждение исходный текст |
| Список | 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 "täst" instead of "t�st", 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 "t�st", 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
В списке pgsql-general по дате отправления: