Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 4BCBA9FB1E7 for ; Tue, 28 Nov 2006 05:21:48 -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 48529-06 for ; Tue, 28 Nov 2006 05:21:29 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mx1.ipf.is (mack.ipf.is [85.197.192.164]) by postgresql.org (Postfix) with ESMTP id 46C719FA430 for ; Tue, 28 Nov 2006 05:21:29 -0400 (AST) Received: (qmail 26665 invoked by uid 1010); 28 Nov 2006 09:18:41 +0000 Received: from 88.149.106.19 by mack (envelope-from , uid 1008) with qmail-scanner-1.25-st-qms (clamdscan: 0.88.4/1639. spamassassin: 3.1.4. perlscan: 1.25-st-qms. Clear:RC:1(88.149.106.19):SA:0(-2.3/4.5):. Processed in 0.307528 secs); 28 Nov 2006 09:18:41 -0000 X-Antivirus-HIVE-Mail-From: gnari@hive.is via mack X-Antivirus-HIVE: 1.25-st-qms (Clear:RC:1(88.149.106.19):SA:0(-2.3/4.5):. Processed in 0.307528 secs Process 26657) Received: from dsl-149-106-19.hive.is (HELO ?192.168.1.33?) (88.149.106.19) by mx1.ipf.is with SMTP; 28 Nov 2006 09:18:40 +0000 Subject: Re: UNICODE and PL/PGSQL From: Ragnar To: Bart Degryse Cc: pgsql-sql@postgresql.org In-Reply-To: <456BFDEE.A3DD.0030.0@indicator.be> 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> <456BFDEE.A3DD.0030.0@indicator.be> Content-Type: text/plain; charset=ISO-8859-1 Date: Tue, 28 Nov 2006 09:28:18 +0000 Message-Id: <1164706098.27070.135.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.4.1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/272 X-Sequence-Number: 26924 On ūri, 2006-11-28 at 09:14 +0100, Bart Degryse wrote: > Yes, I tried and it didn't work. PostgreSQL surely makes something of > it, but not the right characters. maybe you should show us exacly what you did, and what you got, and what you expected > Unless Markus can make his idea using "decode" work, this might be > something pl/pgsql cannot do. did you try the function I posted yesterday elsewhere in this thread? gnari