The following bug has been logged online:
Bug reference: 1557
Logged by: Staffan Sandberg
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.6-1.FC2.2
Operating system: Fedora Core 2
Description: UPPER() and LOWER() do not return the right characters
Details:
Hi,
I am using a PostgreSQL DB with the LATIN1 (ISO-8859-1) character encoding.
When using the UPPER() or LOWER() functions on any of our swedish specific
characters the returned character is never transformed to the desired case.
The functions only return the same character as the input, disregarding of
the input character's case.
E.g: LOWER('Ö') should return 'ö' but instead 'Ö' is returned.
The concerned characters are:
LOWER UPPER
å Å
ä Ä
ö Ö
To solve the problem I am now forced to use the REPLACE() function for these
three characters, hence it would be more convinient if the LOWER() and
UPPER() functions worked properly.
Please make a comment on my report!
Kind regards,
Staffan Sandberg
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
