From: Tom Lane <tgl@sss.pgh.pa.us>
To: Kailash Vyas <kailash.vyas@gmail.com>
Cc: pgsql-admin@postgresql.org
Cc: pankaj@interlink-marketing.net
Subject: Re: encoding issue with postgres 8.0
Date: Tue, 23 Aug 2005 10:20:00 -0400
Message-ID: <2130.1124806800@sss.pgh.pa.us> (raw)
In-Reply-To: <a3cc7917050823045457dfe249@mail.gmail.com>
References: <a3cc7917050823045457dfe249@mail.gmail.com>
Kailash Vyas <kailash.vyas@gmail.com> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, kailash.vyas@gmail.com, pankaj@interlink-marketing.net
Subject: Re: encoding issue with postgres 8.0
In-Reply-To: <2130.1124806800@sss.pgh.pa.us>
References: <a3cc7917050823045457dfe249@mail.gmail.com> <2130.1124806800@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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