Re: initdb locale discrepancy - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: initdb locale discrepancy
Date
Msg-id 48E5C376.6000006@gmx.net
Whole thread Raw
In response to initdb locale discrepancy  ("Subbiah Stalin-XCGF84" <SSubbiah@Motorola.com>)
List pgsql-admin
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.


pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: FW: Upgrade to 8.3
Next
From: "Ray Madigan"
Date:
Subject: Upgrade to 8.3