pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedinitdb locale discrepancy
2+ messages / 2 participants
[nested] [flat]
* initdb locale discrepancy
@ 2008-10-02 20:02 Subbiah Stalin-XCGF84 <SSubbiah@Motorola.com>
2008-10-03 07:02 ` Re: initdb locale discrepancy Peter Eisentraut <peter_e@gmx.net>
0 siblings, 1 reply; 2+ messages in thread
From: Subbiah Stalin-XCGF84 @ 2008-10-02 20:02 UTC (permalink / raw)
To: pgsql-admin
Hi All,
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. Will there be any performance impact in
processing the queries etc.
Message while init DB:
"The files belonging to this database system will be owned by user
"postgres".
This user must also own the server process.
The database cluster will be initialized with locales
COLLATE: en_US.ISO8859-1
CTYPE: en_US.ISO8859-1
MESSAGES: C
MONETARY: en_US.ISO8859-1
NUMERIC: en_US.ISO8859-1
TIME: C
initdb: warning: encoding mismatch
The encoding you selected (UTF8) and the encoding that the selected
locale uses (ISO8859-1) 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."
Your input is appreciated.
Thanks,
Stalin
Env: Solaris 10, PG 8.2.7
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: initdb locale discrepancy
2008-10-02 20:02 initdb locale discrepancy Subbiah Stalin-XCGF84 <SSubbiah@Motorola.com>
@ 2008-10-03 07:02 ` Peter Eisentraut <peter_e@gmx.net>
0 siblings, 0 replies; 2+ messages in thread
From: Peter Eisentraut @ 2008-10-03 07:02 UTC (permalink / raw)
To: Subbiah Stalin-XCGF84 <SSubbiah@Motorola.com>; +Cc: 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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-10-03 07:02 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-10-02 20:02 initdb locale discrepancy Subbiah Stalin-XCGF84 <SSubbiah@Motorola.com>
2008-10-03 07:02 ` Peter Eisentraut <peter_e@gmx.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox