hernan gonzalez <hgonzalez@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general