Re: Using UTF strings in pg8.3 - storing hexadecimal values in bytea columns

Mario Splivalo wrote:
> But, if I want it other way around, I get the error:
>
> test1=# select envode(E'\305', 'hex');
> ERROR: invalid byte sequence for encoding "UTF8": 0xc5
> HINT: This error can also happen if the byte sequence does not match
> the encoding expected by the server, which is controlled by
> "client_encoding".
> test1=#
>
> Is there a way to circumvent encoding when dealing with binary data? Or
> am I completely confused here and have no clue what am I talking about?
>

Now, this works:

test1=# select encode(decode('C5', 'hex'), 'hex');
encode
--------
c5
(1 row)

I see that my client encoding has a problem interpreting '\xC5':

test1=# select E'\xC5';
ERROR: invalid byte sequence for encoding "UTF8": 0xc5
HINT: This error can also happen if the byte sequence does not match
the encoding expected by the server, which is controlled by
"client_encoding".

So the only way is to use decode function, right?

Mike