X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7302054E05 for ; Wed, 23 Feb 2005 21:11:03 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 39590-04 for ; Wed, 23 Feb 2005 21:10:57 +0000 (GMT) Received: from ns1.turtle-entertainment.de (ns1.turtle-entertainment.de [193.41.200.20]) by svr1.postgresql.org (Postfix) with ESMTP id 4808354DA7 for ; Wed, 23 Feb 2005 21:10:55 +0000 (GMT) Received: from ip96.85.1311c-cud12k-02.ish.de ([62.143.85.96] helo=mail.office.turtle-entertainment.de) by ns1.turtle-entertainment.de with asmtp (Exim 3.22 #3 (Debian)) id 1D43ma-0008A0-00 for ; Wed, 23 Feb 2005 22:10:56 +0100 Received: from ip19.1.1411j-cud12k-02.ish.de ([62.143.1.19] helo=[192.168.100.5]) by mail.office.turtle-entertainment.de with asmtp (Exim 3.22 #7 (Debian)) id 1D43mZ-00038I-00 for ; Wed, 23 Feb 2005 22:10:55 +0100 Message-ID: <421CF15C.6010306@turtle-entertainment.de> Date: Wed, 23 Feb 2005 22:10:52 +0100 From: Bjoern Metzdorf User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Pgsql-Admin (E-mail)" Subject: invalid multibyte character for locale Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.861 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, RCVD_IN_NJABL_DUL, RCVD_IN_SORBS_DUL X-Spam-Level: * X-Archive-Number: 200502/270 X-Sequence-Number: 16438 Hi, I am testdriving postgresql 8.0.1. On importing my old dump which works fine on 7.4.6 I am getting errors like this one: CREATE INDEX foobar_uvalue_key ON foobar USING btree (upper((value)::text)); ERROR: invalid multibyte character for locale HINT: The server's LC_CTYPE locale is probably incompatible with the database encoding. pg_controldatas output (this is an EM64T machine (debian pure64), but the issue also comes on 32bit Linux): pg_control version number: 74 Catalog version number: 200411041 Database system identifier: 4763589314759867390 Database cluster state: in production pg_control last modified: Wed Feb 23 22:07:43 2005 Current log file ID: 1 Next log file segment: 214 Latest checkpoint location: 1/D56163E8 Prior checkpoint location: 1/D56163A0 Latest checkpoint's REDO location: 1/D56163E8 Latest checkpoint's UNDO location: 0/0 Latest checkpoint's TimeLineID: 1 Latest checkpoint's NextXID: 3704 Latest checkpoint's NextOID: 50861184 Time of latest checkpoint: Wed Feb 23 21:40:25 2005 Database block size: 8192 Blocks per segment of large relation: 131072 Bytes per WAL segment: 16777216 Maximum length of identifiers: 64 Maximum number of function arguments: 32 Date/time type storage: floating-point numbers Maximum length of locale name: 128 LC_COLLATE: C LC_CTYPE: C Should I be using de_DE or de_DE.UTF_8 locale? C locale always worked fine for us (with 7.3 and 7.4). Any hints? Regards, Bjoern