From: kumar <sgnerd@yahoo.com.sg>
To: Richard Huxton <dev@archonet.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Customised Encoding
Date: Wed, 28 Apr 2004 02:18:43 -0400
Message-ID: <006601c42ce8$a9cee580$7502a8c0@hdsc.com> (raw)
References: <00f501c42c24$7c16f2a0$7502a8c0@hdsc.com>
<200404271309.55818.dev@archonet.com>
<020c01c42c56$ec39b130$7502a8c0@hdsc.com>
<200404271416.16156.dev@archonet.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sgnerd@yahoo.com.sg, dev@archonet.com
Subject: Re: Customised Encoding
In-Reply-To: <006601c42ce8$a9cee580$7502a8c0@hdsc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox