Re: UNICODE and PL/PGSQL

From: Ragnar <gnari(at)hive(dot)is>
To: Bart Degryse <Bart(dot)Degryse(at)indicator(dot)be>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: UNICODE and PL/PGSQL
Date: 2006-11-27 14:37:31
Message-ID: 1164638251.27070.45.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On mán, 2006-11-27 at 11:52 +0100, Bart Degryse wrote:
> Dear all,
> This works: SELECT '\x65'; => it returns the letter 'e'.

yes, but:
test=# select '\x'||'65';
?column?
----------
x65
(1 row)

> When I do the following in PL/PGSQL ....

> FOR i IN 101..101 LOOP
> charset := charset || '\x' || to_hex(i);
> END LOOP;

gnari

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bart Degryse 2006-11-27 14:54:47 Re: UNICODE and PL/PGSQL
Previous Message Markus Schaber 2006-11-27 13:48:06 Re: [SQL] PgAgent [where is it?]