Re: [SQL] Customised Encoding

2004-04-27 Thread kumar
to convert any 16 bit to a single charactor. Is there any function to do that in Postgres. Thanks Kumar - Original Message - From: "Richard Huxton" <[EMAIL PROTECTED]> To: "kumar" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, April 27, 2004

Re: [SQL] Customised Encoding

2004-04-27 Thread Richard Huxton
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'

Re: [SQL] Customised Encoding

2004-04-27 Thread Richard Huxton
On Tuesday 27 April 2004 07:54, kumar wrote: > Dear Friends, > > Postgres 7.3.2 Runing on Linux 7.2 > > I would like to convert any values in between 1 to 2^16 into a single > charactor. And decode that single char to get back the numeric value again. > Any function to do that in Postgres SQL Serve

[SQL] Customised Encoding

2004-04-27 Thread kumar
Dear Friends,   Postgres 7.3.2 Runing on Linux 7.2   I would like to convert any values in between 1 to 2^16 into a single charactor. And decode that single char to get back the numeric value again. Any function to do that in Postgres SQL Server.   Please shed some light.   Thanks Kumar