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?