Try the replacement upper/lower functions that I wrote: http://archives.postgresql.org/pgsql-hackers/2005-02/msg00102.php
Kind regards, John Hansen > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Staffan Sandberg > Sent: Tuesday, March 22, 2005 8:28 PM > To: [email protected] > Subject: [BUGS] BUG #1557: UPPER() and LOWER() do not return > the right characters > > > 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 > > ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
