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 5071D5621A for ; Wed, 23 Feb 2005 21:12:57 +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 39635-08 for ; Wed, 23 Feb 2005 21:12:55 +0000 (GMT) Received: from ns1.turtle-entertainment.de (ns1.turtle-entertainment.de [193.41.200.20]) by svr1.postgresql.org (Postfix) with ESMTP id 596FE55FF8 for ; Wed, 23 Feb 2005 21:12:49 +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 1D43oQ-00005p-00 for ; Wed, 23 Feb 2005 22:12:50 +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 1D43oP-0003BN-00 for ; Wed, 23 Feb 2005 22:12:49 +0100 Message-ID: <421CF1CE.3000800@turtle-entertainment.de> Date: Wed, 23 Feb 2005 22:12:46 +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: Re: invalid multibyte character for locale References: <421CF15C.6010306@turtle-entertainment.de> In-Reply-To: <421CF15C.6010306@turtle-entertainment.de> 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.857 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/271 X-Sequence-Number: 16439 I forgot to say that I am using UNICODE for database encoding (initdb -E UNICODE and createdb -E UNICODE). Bjoern Metzdorf wrote: > 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 >