Thread: Bug #823: upper() does not handle å, ä and ö correctly.

Marcus Andersson (maran@fyrplus.se) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
upper() does not handle å, ä and ö correctly.

Long Description
The function upper() just leaves the letters å, ä, and ö unmodified. It should replace them with Å, Ä and Ö
respectively.

PostgreSQL version 7.2.3 on Solaris.

I am using encoding 7 (ISO 8859-1).

Sample Code


No file was uploaded with this report

On Tue, 26 Nov 2002 pgsql-bugs@postgresql.org wrote:

> Marcus Andersson (maran@fyrplus.se) reports a bug with a severity of 2
> The lower the number the more severe it is.
>
> Short Description
> upper() does not handle �, � and � correctly.
>
> Long Description
> The function upper() just leaves the letters �, �, and � unmodified.
> It should replace them with �, � and � respectively.
>
> PostgreSQL version 7.2.3 on Solaris.
>
> I am using encoding 7 (ISO 8859-1).

It's probably a locale issue.  What locale did you initdb in?

pgsql-bugs@postgresql.org writes:
> upper() does not handle å, ä and ö correctly.

Sounds like you didn't set your locale correctly --- this is not an
encoding issue, it is a locale issue.

            regards, tom lane