Received: from mx99.openu.ac.il (arbel.openu.ac.il [147.233.32.4]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA80721 for ; Sun, 9 May 1999 10:38:24 -0400 (EDT) (envelope-from herouth@oumail.openu.ac.il) Received: from talmon.openu.ac.il (talmon.openu.ac.il [147.233.32.11]) by mx99.openu.ac.il (Postfix) with ESMTP for id D05214B52F; Sun, 9 May 1999 17:38:23 +0300 (IDT) Received: from [147.233.159.109] (mac-herouth.pc.openu.ac.il) by talmon.openu.ac.il (Netscape Messaging Server 3.54) with ESMTP id AAA39BA; Sun, 9 May 1999 17:40:38 +0300 X-Sender: herouth@shaked.cc.openu.ac.il Message-Id: In-Reply-To: <37346D43.419B4AFA@steffen.stade.net> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Date: Sun, 9 May 1999 17:39:12 +0300 To: Henrik Steffen From: Herouth Maoz Subject: Re: [SQL] TRANSLATE() Cc: pgsql-sql@postgreSQL.org Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id KAA80722 At 19:58 +0300 on 08/05/1999, Henrik Steffen wrote: > I wonder how I can translate some German special characters for an ORDER > BY clause. > > say, you got some German words like these: > > Abend > Ära > Opa > Österreich > Übergabe > Ufer Just a minute, did you set the proper locale in your environment? Postgres is supposed to be locale-friendly. Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma