decode function
Started by gerard manvuover 22 years ago2 messagesbugs
Hi
I don't know if it is really a bug or a missuse of postgresql but when I issue the following request
select decode(encode('µ'::bytea, 'escape'), 'escape');
, the result is \346, not 'µ'.
Any help or a forum link ?
Thanks in advance
Gerard.
PS: PostGreSQL 7.4, Red Hat 8, Base under SQL_ASCII or UNICODE (doesn't work either)
Les noms de domaine les moins chers du marché : 6,49 euros HT sur http://www.lycos.fr/pro .
Re: decode function
gerard manvu wrote:
I don't know if it is really a bug or a missuse of postgresql but
when I issue the following request select decode(encode('�'::bytea,
'escape'), 'escape');
, the result is \346, not '�'.
That's the same thing. bytea stores bytes, not characters, so we expect
that you are primarily interested in the byte value.