Message-ID: <006601c42ce8$a9cee580$7502a8c0@hdsc.com>
From: "kumar" <sgnerd@yahoo.com.sg>
To: "Richard Huxton" <dev@archonet.com>
Cc: <pgsql-sql@postgresql.org>
References: <00f501c42c24$7c16f2a0$7502a8c0@hdsc.com>
	<200404271309.55818.dev@archonet.com>
	<020c01c42c56$ec39b130$7502a8c0@hdsc.com>
	<200404271416.16156.dev@archonet.com>
Subject: Re: Customised Encoding
Date: Wed, 28 Apr 2004 02:18:43 -0400
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

The idea is I wanna store any number from 1 to 2^16 in 2 strings only - This
is the requirement.
Since in Unicode a 16 bit is represented in a Single chararctor.
So i wanna convert any number into a 32 bit  and then convert each 16 bit
into one char and stored it in database.

So I wanna know how 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" <dev@archonet.com>
To: "kumar" <sgnerd@yahoo.com.sg>
Cc: <pgsql-sql@postgresql.org>
Sent: Tuesday, April 27, 2004 9:16 AM
Subject: Re: [SQL] 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