Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id B149B9FA252 for ; Mon, 27 Nov 2006 12:31:43 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 07390-07 for ; Mon, 27 Nov 2006 12:31:30 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75]) by postgresql.org (Postfix) with ESMTP id F27999FA231 for ; Mon, 27 Nov 2006 12:31:29 -0400 (AST) Received: from mainbox.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id 2C23E14C8DD; Mon, 27 Nov 2006 16:31:29 +0000 (GMT) Received: from [192.168.1.17] (client17.office.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id 89ABA15EAB; Mon, 27 Nov 2006 16:31:28 +0000 (GMT) Message-ID: <456B13AE.1090100@archonet.com> Date: Mon, 27 Nov 2006 16:34:54 +0000 From: Richard Huxton User-Agent: Thunderbird 1.5.0.8 (X11/20061115) MIME-Version: 1.0 To: Bart Degryse Cc: ", pgsql-sql@postgresql.org 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> <456B1ACF020000300000FC74@webaccess.indicator.be> In-Reply-To: <456B1ACF020000300000FC74@webaccess.indicator.be> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/266 X-Sequence-Number: 26918 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