Received: from sraigw.sra.co.jp (sraigw.sra.co.jp [202.32.10.2]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f7V10Af51964 for ; Thu, 30 Aug 2001 21:00:11 -0400 (EDT) (envelope-from t-ishii@sra.co.jp) Received: from sranhm.sra.co.jp (sranhm [133.137.13.152]) by sraigw.sra.co.jp (8.8.7/3.7W-sraigw) with ESMTP id JAA00573; Fri, 31 Aug 2001 09:59:54 +0900 (JST) Received: from localhost (IDENT:t-ishii@srapc1474.sra.co.jp [133.137.13.54]) by sranhm.sra.co.jp (8.9.3+3.2W/3.7W-srambox) with ESMTP id JAA14278; Fri, 31 Aug 2001 09:59:54 +0900 To: doc@lublin.t1.pl Cc: pgsql-sql@postgresql.org Subject: Re: Latin-2 sort order In-Reply-To: <20010830222850.A6795@lublin.t1.pl> References: <20010830021641.A1324@lublin.t1.pl> <20010830105506H.t-ishii@sra.co.jp> <20010830222850.A6795@lublin.t1.pl> X-Mailer: Mew version 1.94.2 on Emacs 20.7 / Mule 4.1 =?iso-2022-jp?B?KBskQjAqGyhCKQ==?= Mime-Version: 1.0 Content-Type: Text/Plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-Id: <20010831095942N.t-ishii@sra.co.jp> Date: Fri, 31 Aug 2001 09:59:42 +0900 From: Tatsuo Ishii X-Dispatcher: imput version 20000228(IM140) Lines: 25 X-Archive-Number: 200108/375 X-Sequence-Number: 4634 > > You need to enable locale support. MB support does nothing with the > > sort order. > > I guess You mean: > > ./configure --enable-locale > export LANG=pl_PL > run postmaster Yes. > and now should I > > initdb > > or just simply browse the database as usual? I'm afraid you are forced initdb. I think postmaster coming with PostgreSQL 7.1 or later won't start up if locale is enabled and the specified locale is different from the initdb time (if locale is not enabled in PostgreSQL, the current locale would be assumed as C). -- Tatsuo Ishii