Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
Lists: pgsql-adminpgsql-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. 



pgsql-admin by date

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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group