X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8AD39D6F05 for ; Tue, 23 Aug 2005 08:54:54 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 30786-10 for ; Tue, 23 Aug 2005 11:54:50 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.195]) by svr1.postgresql.org (Postfix) with ESMTP id C7BBED6E7F for ; Tue, 23 Aug 2005 08:54:48 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id i4so1174961wra for ; Tue, 23 Aug 2005 04:54:51 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:mime-version:content-type; b=QWp4T1G95JiT8S+A/cY93WdlMUNrK7XCzLCRJnFJrUN2R8fbhJhH0vl37ap5UnHD1gS9dWgBeKR+F3CGUanslqvCo04l4OKk8jf670QLopyp3tsE5dtFZPDV1y2qez0tQqfLhVPsEo4kbb27Nxh6c9i+iYH6wBPulCrArKWAHIU= Received: by 10.54.147.16 with SMTP id u16mr2146470wrd; Tue, 23 Aug 2005 04:54:51 -0700 (PDT) Received: by 10.54.131.17 with HTTP; Tue, 23 Aug 2005 04:54:51 -0700 (PDT) Message-ID: Date: Tue, 23 Aug 2005 12:54:51 +0100 From: Kailash Vyas To: pgsql-admin@postgresql.org Subject: encoding issue with postgres 8.0 Cc: pankaj@interlink-marketing.net Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2334_29863798.1124798091146" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.322 required=5 tests=[AWL=0.002, HTML_10_20=0.295, HTML_MESSAGE=0.001, RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200508/279 X-Sequence-Number: 18598 ------=_Part_2334_29863798.1124798091146 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline hi=20 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=20 "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 ------=_Part_2334_29863798.1124798091146 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 "pos= tgres".
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<= br> 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
------=_Part_2334_29863798.1124798091146--