Re: psql weird behaviour with charset encodings - Mailing list pgsql-general

From Tom Lane
Subject Re: psql weird behaviour with charset encodings
Date
Msg-id 2117.1273270375@sss.pgh.pa.us
Whole thread Raw
In response to Re: psql weird behaviour with charset encodings  (hernan gonzalez <hgonzalez@gmail.com>)
Responses Re: psql weird behaviour with charset encodings
List pgsql-general
hernan gonzalez <hgonzalez@gmail.com> writes:
> But I actually dont want that. I want psql to not try any charset
> conversion, just give me the raw text as is stored in the db.

Well, that's what it's doing (given the default setting with
client_encoding equal to server_encoding), and then xterm is
misdisplaying the text because xterm thinks it's utf8.  I'm
not very clear on why the \x case seems to display correctly
anyway, but you really need the terminal's encoding to agree
with client_encoding in order to get non-ASCII characters to
work well.

            regards, tom lane

pgsql-general by date:

Previous
From: hernan gonzalez
Date:
Subject: Re: psql weird behaviour with charset encodings
Next
From: hernan gonzalez
Date:
Subject: Re: psql weird behaviour with charset encodings