Home > mailing lists

Problems with the lower() and upper() functions and umlaut chars in 7.2 - Mailing list pgsql-hackers

From	soetebeer.com
Subject	Problems with the lower() and upper() functions and umlaut chars in 7.2
Date	February 22, 2002 11:30:09
Msg-id	HMEAJFHEDLMIKOIDKAIAGEKKCNAA.frank@soetebeer.com Whole thread Raw
List	pgsql-hackers

Tree view

Hi all,
I currently encountered problems when executing the lower() and upper()
functions on strings that contain
special (umlaut) chars.
The db version is 7.2 and the database is created as UNICODE.

When f.e. selecting the following "select lower('Ö');" the result is still
the Uppercase 'Ö'. Postgres leaves
this untouched.

Did I have to make some settings to LANG or other things ?


Please help.


Thanks,
Frank

pgsql-hackers by date:

From: Hannu Krosing
Date: 22 February 2002, 11:30:07
Subject: Re: PostgreSQL 8.0 ??

From: Ruslan A Dautkhanov
Date: 22 February 2002, 11:35:03
Subject: Re: date/time compatible problems in 7.2

Problems with the lower() and upper() functions and umlaut chars in 7.2 - Mailing list pgsql-hackers

Previous

Next