Re: UNICODE and PL/PGSQL - Mailing list pgsql-sql

From Bart Degryse
Subject Re: UNICODE and PL/PGSQL
Date
Msg-id 456BFDEE.A3DD.0030.0@indicator.be
Whole thread Raw
In response to Re: UNICODE and PL/PGSQL  (Richard Huxton <dev@archonet.com>)
Responses Re: UNICODE and PL/PGSQL
List pgsql-sql
Yes, I tried and it didn't work. PostgreSQL surely makes something of it, but not the right characters.
Unless Markus can make his idea using "decode" work, this might be something pl/pgsql cannot do.

>>> Richard Huxton <dev@archonet.com> 2006-11-27 17:34 >>>
Bart Degryse wrote:
> As the manual says : Character with the given ASCII code
> I need characters outside the ASCII range. Something like
>   charset := charset || '\xC2\x' || to_hex(i)';

Well, if you've tried it for characters > 127 and it didn't work then I
don't know that it is possible at all. You *did* try the function?

--
   Richard Huxton
   Archonet Ltd

pgsql-sql by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: select into
Next
From: "Bart Degryse"
Date:
Subject: Re: UNICODE and PL/PGSQL