Обсуждение: TRANSLATE()

Hello all,

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

and want to order them in the way above, you will need to translate 'Ä'
into 'Ae', 'Ö' into 'Oe' and 'Ü' into 'Ue' to order them correctly.

I thought of something like this:
SELECT myword FROM words ORDER BY TRANSLATE(myword,'Ä','Ae');

But now I only got one of the cases. How can I combine all the three
translations?

Any help appreciated!


Greetings

Henrik Steffen
http://www.AH-Tuning.de

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