Huge problem with upper/lower and foreign chars - Mailing list pgsql-general

From Victor Spång Arthursson
Subject Huge problem with upper/lower and foreign chars
Date
Msg-id 1AE1A992-A0DF-45C0-B032-84DDFB2F5515@tosti.dk
Whole thread Raw
Responses Re: Huge problem with upper/lower and foreign chars
List pgsql-general
Ciao again!

I just ran into a huge problem with the functions upper and lower…

It turns out, that when converting the case of foreign characters,
like åäö, they stay as they were from the beginning…

Example:

SQL = select 'test åÄöØ', upper('test åÄöØ'), lower('test åÄöØ')

Result:

?column?    upper                  lower
test åÄöØ    TEST åÄöØ        test åÄöØ

This makes searches impossible for me, since postgres is case sensitive…

I would really really appreciate some input on this matter…

Best regards,

Victor Spång Arthursson

pgsql-general by date:

Previous
From: "Devrim GUNDUZ"
Date:
Subject: Re: Postgres 8.0.3 Fedora RPMS ?
Next
From: Stephane Bortzmeyer
Date:
Subject: Re: REFERENCES ignored when there is inheritance?