Обсуждение: Huge problem with upper/lower and foreign chars

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

On Fri, 13 May 2005, [ISO-8859-1] Victor Sp�ng Arthursson wrote:

> 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�

To help people try to find out what is going on, what version of
PostgreSQL, encoding and locale are you using?