X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2CF4F8B9C90 for ; Tue, 1 Feb 2005 18:36:23 +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 00367-08 for ; Tue, 1 Feb 2005 18:36:21 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 8B3288B9C8C for ; Tue, 1 Feb 2005 18:36:20 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j11IaEqu016249; Tue, 1 Feb 2005 13:36:14 -0500 (EST) To: Theodore Petrosky Cc: pgsql-sql@postgresql.org, Peter Eisentraut Subject: Re: case sensitive/insensitive confusion In-reply-to: <20050201124858.38440.qmail@web41006.mail.yahoo.com> References: <20050201124858.38440.qmail@web41006.mail.yahoo.com> Comments: In-reply-to Theodore Petrosky message dated "Tue, 01 Feb 2005 04:48:57 -0800" Date: Tue, 01 Feb 2005 13:36:14 -0500 Message-ID: <16248.1107282974@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/29 X-Sequence-Number: 20140 Theodore Petrosky writes: > Mac os x, postgresql 8.0.1 > initdb --locale=es_ES ~/testdb > ... > The database cluster will be initialized with locale es_ES. > initdb: could not find suitable encoding for locale "es_ES" > Rerun initdb with the -E option. I looked into this and find that the issue seems to be Apple's rather limited (not to say brain dead) locale support. What I see on OSX 10.3.7 is that defines CODESET, but nl_langinfo(CODESET) always returns an empty string. So there's not any obvious way to determine the correct encoding associated with a locale setting. regards, tom lane