Try the replacement upper/lower functions that I wrote:
> -----Original Message-----
> From: pgsql-bugs-owner(at)postgresql(dot)org
> [mailto:pgsql-bugs-owner(at)postgresql(dot)org] On Behalf Of Staffan Sandberg
> Sent: Tuesday, March 22, 2005 8:28 PM
> To: pgsql-bugs(at)postgresql(dot)org
> 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: staffan(dot)sandberg(at)fhd(dot)se
> PostgreSQL version: 7.4.6-1.FC2.2
> Operating system: Fedora Core 2
> Description: UPPER() and LOWER() do not return the
> right characters
> 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
> TIP 4: Don't 'kill -9' the postmaster
pgsql-bugs by date
|Next:||From: John Hansen||Date: 2005-03-27 10:12:44|
|Subject: Re: BUG #1557: UPPER() and LOWER() do not return the right characters|
|Previous:||From: Tom Lane||Date: 2005-03-27 08:12:37|
|Subject: Re: BUG #1558: memory leak in libpq connectDBStart() |