Received: from mailhub1.isdnet.net (mailhub1.isdnet.net [195.154.209.21]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9SA9tP82105 for ; Sun, 28 Oct 2001 05:09:56 -0500 (EST) (envelope-from jm.poure@freesurf.fr) Received: from station ([195.154.28.3]) by mailhub1.isdnet.net (8.9.3/8.9.3) with ESMTP id LAA94339; Sun, 28 Oct 2001 11:06:03 +0100 (CET) Message-Id: <4.2.0.58.20011028105901.00cfe720@pop.freesurf.fr> X-Sender: jm.poure@pop.freesurf.fr X-Mailer: QUALCOMM Windows Eudora Pro Version 4.2.0.58 Date: Sun, 28 Oct 2001 11:06:00 +0100 To: Marko Kreen From: Jean-Michel POURE Subject: Re: UNICODE Cc: pgsql-hackers@postgresql.org In-Reply-To: <20011028115041.A12320@l-t.ee> References: <4.2.0.58.20011028085953.00cfa740@pop.freesurf.fr> <4.2.0.58.20011028085953.00cfa740@pop.freesurf.fr> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200110/979 X-Sequence-Number: 14702 >1) Did you compile PostgreSQL with --enable-locale Yes. >2) Did you set correct locale for postmaster (LANG=xxx) Database was create using CREATE db WITH ENCODING='UNICODE'. pgsql: \encoding returns UNICODE. The db stores multiple languages (French, English, Japanese). Why should I define a *single* locale for postmaster? Do I miss something? Best regards, Jean-Michel POURE