X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6F979D6F60 for ; Tue, 23 Aug 2005 11:20:04 -0300 (ADT) 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 30446-06 for ; Tue, 23 Aug 2005 14:20:01 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 91938D6F55 for ; Tue, 23 Aug 2005 11:20:00 -0300 (ADT) 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 j7NEK0Ow002131; Tue, 23 Aug 2005 10:20:00 -0400 (EDT) To: Kailash Vyas Cc: pgsql-admin@postgresql.org, pankaj@interlink-marketing.net Subject: Re: encoding issue with postgres 8.0 In-reply-to: References: Comments: In-reply-to Kailash Vyas message dated "Tue, 23 Aug 2005 12:54:51 +0100" Date: Tue, 23 Aug 2005 10:20:00 -0400 Message-ID: <2130.1124806800@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200508/281 X-Sequence-Number: 18600 Kailash Vyas writes: > The database cluster will be initialized with locale en_GB.UTF-8. > initdb: warning: encoding mismatch > The encoding you selected (SQL_ASCII) and the encoding that the selected > locale uses (UTF-8) are not known to match. This may lead to > misbehavior in various character string processing functions. To fix > this situation, rerun initdb and either do not specify an encoding > explicitly, or choose a matching combination. > what is the matching locale that i should be using in this case? If you want to use SQL_ASCII (ie, have no enforcement of encoding validity) the only really safe locale is "C". If you were using another combination with your old database and not having trouble, you may decide to ignore the warning and keep using that combination --- it'll work just as well or badly as before. But with what you have here, if you ever accidentally put any non-UTF8 data into the database, you'll likely get odd behavior. regards, tom lane