Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id C75F49FB53C for ; Sat, 24 Feb 2007 11:23:22 -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 31705-05 for ; Sat, 24 Feb 2007 11:23:13 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by postgresql.org (Postfix) with ESMTP id 6D1249FB54B for ; Sat, 24 Feb 2007 11:23:19 -0400 (AST) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.8/8.13.8) with ESMTP id l1OFNBo2010498 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Sat, 24 Feb 2007 08:23:13 -0700 (MST) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.8/8.13.8) with ESMTP id l1OFNAqJ059689; Sat, 24 Feb 2007 08:23:10 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.8/8.13.8/Submit) id l1OFNAcp059688; Sat, 24 Feb 2007 08:23:10 -0700 (MST) (envelope-from mfuhr) Date: Sat, 24 Feb 2007 08:23:10 -0700 From: Michael Fuhr To: j n Cc: pgsql-admin@postgresql.org Subject: Re: can i use to_ascii function ? Message-ID: <20070224152310.GA59489@winnie.fuhr.org> References: <46f93e0d0702230412i7a576ef9jd85c2823fa2c65e5@mail.gmail.com> <20070223142439.GA13593@winnie.fuhr.org> <46f93e0d0702240141y7659efbm8823877015b8e691@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <46f93e0d0702240141y7659efbm8823877015b8e691@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/314 X-Sequence-Number: 24779 [Please reply to the mailing list so others can participate in and learn from the discussion.] On Sat, Feb 24, 2007 at 10:41:51AM +0100, j n wrote: > maybe one more suggestion ... > this type > > to_ascii(convert(lastname, 'LATIN2'), 'LATIN2') > > was not working fine unless i use ./configure --with-perl option i don't > know if this is real reason ..., but i have not change anything else ... The above expression has nothing to do with Perl unless perhaps you have like-named PL/Perl functions in your database and you've set search_path to find them ahead of the ones in pg_catalog, which is unlikely. I suspect that the relevant difference between your test environments is something else. What exactly do you mean by "not working fine"? What did you do, what were you expecting to happen, and what did happen? Can you post a standalone test case? What version of PostgreSQL are you running? What platform? What are the server and client encodings? What are the server's locale settings? -- Michael Fuhr