lower does not handle german umlaut
If I perform a select lower() on uppercased german umlauts, these wont be
converted to lowercase. Is this a bug or a feature or did I just miss
some settings ?
thnx,
peter
--
mag. peter pilsl
phone: +43 676 3574035
fax : +43 676 3546512
email: pilsl@goldfisch.at
sms : pilsl@max.mail.at
pgp-key available
Peter Pilsl <pilsl@goldfisch.at> writes:
If I perform a select lower() on uppercased german umlauts, these wont be
converted to lowercase.
AFAIK this should work if (a) the system was built with --enable-locale
and (b) you are running it in an appropriate locale setting. The
SQL lower() function just invokes the C library's tolower() conversion
routine, so if it doesn't work your beef is with tolower() ...
regards, tom lane
On Wed, 2001-11-07 at 18:12, Tom Lane wrote:
Peter Pilsl <pilsl@goldfisch.at> writes:
If I perform a select lower() on uppercased german umlauts, these wont be
converted to lowercase.AFAIK this should work if (a) the system was built with --enable-locale
and (b) you are running it in an appropriate locale setting. The
SQL lower() function just invokes the C library's tolower() conversion
routine, so if it doesn't work your beef is with tolower() ...
try select to_ascii()
I use it for French
Cheers
Tony Grant
--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html