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 440DC9DCA26 for ; Wed, 28 Dec 2005 10:54:47 -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 84496-02 for ; Wed, 28 Dec 2005 10:54:51 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 30D1A9DCA25 for ; Wed, 28 Dec 2005 10:54:45 -0400 (AST) Received: from mail.ringways.co.uk (host-80-193-83-130.static.telewest.net [80.193.83.130]) by svr4.postgresql.org (Postfix) with ESMTP id 181E85AFF8C for ; Wed, 28 Dec 2005 14:54:49 +0000 (GMT) Received: from eddie.ringways.co.uk ([10.1.1.115]) by mail.ringways.co.uk with esmtp (Exim 4.54) id 1Ercfi-00055r-AT for pgsql-admin@postgresql.org; Wed, 28 Dec 2005 14:52:59 +0000 From: Gary Stainburn Organization: Ringways Garages Ltd To: pgsql-admin@postgresql.org Subject: restored database locale problem Date: Wed, 28 Dec 2005 14:53:01 +0000 User-Agent: KMail/1.8.2 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200512281453.01568.gary.stainburn@ringways.co.uk> 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/340 X-Sequence-Number: 20060 Hi folks. I've just FUBAR'd one of my databases so I dropped it and and then recreated it from a pg_dump taken at 1am today. Everything went fine with no errors or warning while recreating everything, but now one of my selects doesn't work. A quick google and scan of the postgresql hasn't helped. My other databases within the same server are all working fine. Gary goole=# select r_id as key, * from new_request_details where (upper(r_registration) like upper('%D55D4473%') or upper(r_chassis) like upper('%D55D4473%') or upper(r_pack_mats) like upper('%D55D4473%') or upper(c_des) like upper('%D55D4473%') ) order by r_delivery, r_delivery, r_created goole-# ; ERROR: invalid multibyte character for locale HINT: The server's LC_CTYPE locale is probably incompatible with the database encoding. goole=# -- Gary Stainburn This email does not contain private or confidential material as it may be snooped on by interested government parties for unknown and undisclosed purposes - Regulation of Investigatory Powers Act, 2000