X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id A06A09DCACD for ; Sat, 10 Dec 2005 05:55:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 25235-04 for ; Sat, 10 Dec 2005 05:55:33 -0400 (AST) X-Greylist: delayed 00:30:04.776372 by SQLgrey- Received: from smtp.fmi.uni-sofia.bg (lio.fmi.uni-sofia.bg [62.44.101.7]) by postgresql.org (Postfix) with ESMTP id 180009DCAB7 for ; Sat, 10 Dec 2005 05:55:29 -0400 (AST) Received: from poshta.fmi.uni-sofia.bg ([62.44.101.14]) by smtp.fmi.uni-sofia.bg for pgsql-admin@postgresql.org; Sat, 10 Dec 2005 11:21:19 +0200 Received: from 84.22.12.153 (SquirrelMail authenticated user fn30762); by poshta.fmi.uni-sofia.bg with HTTP; Sat, 10 Dec 2005 11:25:23 +0200 (EET) Message-ID: <44235.84.22.12.153.1134206723.squirrel@84.22.12.153> Date: Sat, 10 Dec 2005 11:25:23 +0200 (EET) Subject: case sensitive problem From: "Anton Andreev" To: pgsql-admin@postgresql.org Reply-To: fn30762@fmi.uni-sofia.bg User-Agent: SquirrelMail/1.4.3a X-Mailer: SquirrelMail/1.4.3a MIME-Version: 1.0 Content-Type: text/plain;charset=windows-1251 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/89 X-Sequence-Number: 19809 Hi, I have a db with unicode encoding. I store both English and Bulgerian. collation Bulgerian.1251 ctype Bulgerian.1251 I am using regular expressions ~* which are supposed to be case insensitive, but they are NOT! I need them to be case insensitive. What should I do? Cheers, Anton