Re: Customised Encoding

On Tuesday 27 April 2004 13:55, kumar wrote:
> Hi Richar,

Kumar - try to make sure you reply to the list.

> It didnt work for me.
>
> select encode('65536'::bytea,'UTF-8')
> ERROR:  Cannot cast type integer to bytea
>
> select encode('65536'::bytea,'UTF-8')
> ERROR:  No such encoding as 'UTF-8'

I think you're using the encode() function wrongly. The second parameter is 
supposed to be something like "base64" or "hex". I'm not sure it makes sense 
to try and cast an integer to a bytea either.

Can you say what you're trying to achieve here?

--  Richard Huxton Archonet Ltd