Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 69A5A37BABB for ; Fri, 3 Oct 2008 04:02:21 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 97413-07 for ; Fri, 3 Oct 2008 04:02:20 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 4B52B37BA2F for ; Fri, 3 Oct 2008 04:02:19 -0300 (ADT) Received: (qmail invoked by alias); 03 Oct 2008 07:02:17 -0000 Received: from gmp-ea-fw-1.sun.com (EHLO dhcp-eesp05-101-124.Finland.Sun.COM) [192.18.1.36] by mail.gmx.net (mp010) with SMTP; 03 Oct 2008 09:02:17 +0200 X-Authenticated: #495269 X-Provags-ID: V01U2FsdGVkX18ZC5k/bDgZ3xJ6FmJLbw4LdBEx6s+X5ypQYOFjeC bD9agcAytpXffQ Message-ID: <48E5C376.6000006@gmx.net> Date: Fri, 03 Oct 2008 10:02:14 +0300 From: Peter Eisentraut User-Agent: Thunderbird 2.0.0.17 (Macintosh/20080914) MIME-Version: 1.0 To: Subbiah Stalin-XCGF84 CC: pgsql-admin@postgresql.org Subject: Re: initdb locale discrepancy References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Y-GMX-Trusted: 0 X-FuHaFi: 0.73 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200810/10 X-Sequence-Number: 30466 Subbiah Stalin-XCGF84 wrote: > The following is the message we had got while setting up postgres > database. This message was overlooked when we setup but now we have > found the discrepancies. For now the database are created with encode > type as UTF8 but the locale settings are ISO8859-1 in postgresql.conf. > The question i have is, what will be impact if we don't use any > multibyte characters in the mix. If you only use ASCII characters, then there will be no effect. Else, you might experience incorrect results and possibly crashes when doing sort operations or other string manipulation operations on the affected strings.