pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kailash Vyas <kailash.vyas@gmail.com>
To: pgsql-admin@postgresql.org
Cc: pankaj@interlink-marketing.net
Subject: encoding issue with postgres 8.0
Date: Tue, 23 Aug 2005 12:54:51 +0100
Message-ID: <a3cc7917050823045457dfe249@mail.gmail.com> (raw)

hi 

i am migrating from postgres 7.3.9 to 8.0.3
I am facing a issue with encoding.
By default when i create new database it creates as UNICODE
In the earlier version the encoding was SQL_ASCII

so i am passing this variable while initializing the db directory

/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data -E SQL_ASCII

but i get this warning when I run it.

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 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?


thanks,
kailash

view thread (2+ messages)  latest in thread

Message-ID: <a3cc7917050823045457dfe249@mail.gmail.com>
Permalink:  ../a3cc7917050823045457dfe249@mail.gmail.com/
Also on:    postgresql.org/message-id/a3cc7917050823045457dfe249@mail.gmail.com

 · 

reply

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: kailash.vyas@gmail.com, pankaj@interlink-marketing.net
  Subject: Re: encoding issue with postgres 8.0
  In-Reply-To: <a3cc7917050823045457dfe249@mail.gmail.com>
  References: <a3cc7917050823045457dfe249@mail.gmail.com>

* 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