| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Subbiah Stalin-XCGF84 <SSubbiah(at)Motorola(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: initdb locale discrepancy |
| Date: | 2008-10-03 07:02:14 |
| Message-ID: | 48E5C376.6000006@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | antonis | 2008-10-03 12:29:06 | Try to recover data |
| Previous Message | Alvaro Herrera | 2008-10-03 00:24:25 | Re: FW: Upgrade to 8.3 |