Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id A59FD9FA430
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 28 Nov 2006 04:14:39 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024)
	with ESMTP id 10960-06 for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 28 Nov 2006 04:14:31 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from interscan.indicator.com (mail.indicator.be [193.121.199.3])
	by postgresql.org (Postfix) with ESMTP id 44C619FB1C4
	for <pgsql-sql@postgresql.org>; Tue, 28 Nov 2006 04:14:33 -0400 (AST)
Received: from DOMEXT-MTA by webaccess.indicator.bewith Novell_GroupWise;
	Tue, 28 Nov 2006 09:14:30 +0100
Message-Id: <456BFDEE.A3DD.0030.0@indicator.be>
X-Mailer: Novell GroupWise Internet Agent 7.0.1 
Date: Tue, 28 Nov 2006 09:14:23 +0100
From: "Bart Degryse" <Bart.Degryse@indicator.be>
To: "Richard Huxton" <dev@archonet.com>
Cc: "<Markus Schaber" <schabi@logix-tt.com>,
	<pgsql-sql@postgresql.org>
Subject: Re: UNICODE and PL/PGSQL
References: <456AD17A020000300000FB60@webaccess.indicator.be><1164638251.270
	70.45.camel@localhost.localdomain><456B0A47020000300000FC1E@webaccess.in
	d	i	cator.be><456B0A47020000300000FC1E@webaccess.indicator.be><456B0153.301
	06	03	@logix-tt.com><456B132F020000300000FC4B@webaccess.indicator.be><456B1
	32F	020000300000FC4B@webaccess.indicator.be><456B0A0A.2080009@archonet.com>
	<456B1ACF020000300000FC74@webaccess.indicator.be><456B1ACF020000300000FC74@
	webaccess.indicator.be><456B13AE.1090100@archonet.com>
In-Reply-To: <456B13AE.1090100@archonet.com>
Mime-Version: 1.0
Content-Type: multipart/alternative;
	boundary="=__Part664245CF.2__="
X-imss-version: 2.044
X-imss-result: Passed
X-imss-approveListMatch: *@indicator.be
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200611/270
X-Sequence-Number: 26922

--=__Part664245CF.2__=
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

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 :=3D charset || '\xC2\x' || to_hex(i)';

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

--=20
   Richard Huxton
   Archonet Ltd

--=__Part664245CF.2__=
Content-Type: text/html; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Description: HTML

<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-15=
">
<META content=3D"MSHTML 6.00.2800.1264" name=3DGENERATOR></HEAD>
<BODY style=3D"MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>Yes, I tried and it didn't work. PostgreSQL surely makes something of =
it, but not the right characters.</DIV>
<DIV>Unless Markus can make his idea using "decode" work, this might be =
something pl/pgsql cannot do.<BR><BR>&gt;&gt;&gt; Richard Huxton &lt;dev@ar=
chonet.com&gt; 2006-11-27 17:34 &gt;&gt;&gt;<BR>Bart Degryse wrote:<BR>&gt;=
 As the manual says : Character with the given ASCII code<BR>&gt; I need =
characters outside the ASCII range. Something like<BR>&gt;&nbsp;&nbsp; =
charset :=3D charset || '\xC2\x' || to_hex(i)';<BR><BR>Well, if you've =
tried it for characters &gt; 127 and it didn't work then I <BR>don't know =
that it is possible at all. You *did* try the function?<BR><BR>-- =
<BR>&nbsp;&nbsp; Richard Huxton<BR>&nbsp;&nbsp; Archonet Ltd<BR></DIV></BOD=
Y></HTML>

--=__Part664245CF.2__=--