upper/lower for german characters

From: "Andrei Bintintan" <klodoma(at)ar-sd(dot)net>
To: <pgsql-sql(at)postgresql(dot)org>, <pgsql-admin(at)postgresql(dot)org>
Subject: upper/lower for german characters
Date: 2004-11-09 14:58:27
Message-ID: 022f01c4c66c$933f66f0$0b00a8c0@forge
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

Hi to all, I have the problem that:
select lower('MöBÜEL') or select upper('MöBÜEL') are not working well.

I read on some forums that there is some locale setting that needs to be done here, but could not fix this.

I am using the ASCII encoding.

Please advice.

Thakx.
Andy.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Francisco Jose Bernabe Pellicer 2004-11-09 15:10:56 Re: Where is postgresql??
Previous Message Carlos Lopez 2004-11-09 14:56:31 Re: [PERFORM] poor performance in migrated database

Browse pgsql-sql by date

  From Date Subject
Next Message Theodore Petrosky 2004-11-09 15:24:57 Re: A transaction in transaction? Possible?
Previous Message T E Schmitz 2004-11-09 14:46:02 Re: tricky GROUP BY / JOIN question