"hernan gonzalez" <hgonzalez@xxxxxxxxx> writes:
> test=# create view vchartest as
> select encode(convert_to(c,'LATIN9'),'escape') as c1 from chartest;
Hmm. This isn't a very sensible combination that you've written here,
but I see the point: encode(..., 'escape') is broken in that it fails
to convert high-bit-set bytes into \nnn sequences. At least in
multibyte backend encodings, we *must* do that to produce valid textual
output. I suspect that for consistency we should do it regardless of
backend encoding.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
