Problems with the lower() and upper() functions and umlaut chars in 7.2

From: "soetebeer(dot)com" <frank(at)soetebeer(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Problems with the lower() and upper() functions and umlaut chars in 7.2
Date: 2002-02-21 20:29:42
Message-ID: HMEAJFHEDLMIKOIDKAIAGEKKCNAA.frank@soetebeer.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Browse pgsql-hackers by date

  From Date Subject
Next Message PG Explorer 2002-02-21 20:40:10 Re: [HACKERS] foreign key is from different tables - what to do?
Previous Message Thomas Lockhart 2002-02-21 20:25:44 Re: DateStyle bug