Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id EEB999FA23F for ; Mon, 27 Nov 2006 12:05:36 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 11710-06 for ; Mon, 27 Nov 2006 12:05:28 -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 202B79FA252 for ; Mon, 27 Nov 2006 12:05:27 -0400 (AST) Received: from DOMEXT-MTA by webaccess.indicator.bewith Novell_GroupWise; Mon, 27 Nov 2006 17:05:25 +0100 Message-Id: <456B1ACF020000300000FC74@webaccess.indicator.be> X-Mailer: Novell GroupWise Internet Agent 7.0.1 Date: Mon, 27 Nov 2006 17:05:19 +0100 From: "Bart Degryse" To: "Richard Huxton" Cc: ", Subject: Re: UNICODE and PL/PGSQL References: <456AD17A020000300000FB60@webaccess.indicator.be><1164638251.270 70.45.camel@localhost.localdomain><456B0A47020000300000FC1E@webaccess.ind i cator.be><456B0A47020000300000FC1E@webaccess.indicator.be><456B0153.30106 03 @logix-tt.com><456B132F020000300000FC4B@webaccess.indicator.be><456B132F 020000300000FC4B@webaccess.indicator.be><456B0A0A.2080009@archonet.com> In-Reply-To: <456B0A0A.2080009@archonet.com> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=__PartE5C1C6AF.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/264 X-Sequence-Number: 26916 --=__PartE5C1C6AF.2__= Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable 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)'; >>> Richard Huxton 2006-11-27 16:53 >>> Bart Degryse wrote: > Hi Markus, > I should have said "The ICT department doesn't give me access to the = psql command line interface". > Thanks for explaining what goes wrong. I now understand the problem. It = doesn't solve it though. What's wrong with the chr() function? http://www.postgresql.org/docs/8.1/static/functions-string.html --=20 Richard Huxton Archonet Ltd --=__PartE5C1C6AF.2__= Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Description: HTML

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)';

>>= > Richard Huxton <dev@archonet.com> 2006-11-27 16:53 >>><= BR>

Bart Degryse wrote:
> Hi Markus,
>= ; I should have said "The ICT department doesn't give me access to the = psql command line interface".
> Thanks for explaining what goes = wrong. I now understand the problem. It doesn't solve it though.

Wha= t's wrong with the chr() function?
http://www.postgresql.org/docs/8.1/s= tatic/functions-string.html

--
Richard = Huxton
Archonet Ltd

--=__PartE5C1C6AF.2__=--