[BUGS] BUG #3378: UTF-8 upper() and lower() don't work

[Kenneth Christensen]

The following bug has been logged online:

Bug reference:      3378
Logged by:          Kenneth Christensen
Email address:      [EMAIL PROTECTED]
PostgreSQL version: 8.2
Operating system:   Mac OS 10.4.9
Description:        UTF-8 upper() and lower() don't work
Details: 

I have a DB where encoding is set to UTF-8.

The DB have some tables where some of the columns (varchar) contains danish
chars.

It looks like lower() and upper() ignores the danish chars when I try to
convert to lowercase or uppercase.

E.g.

Case 1:
-------

Column 'name' contains 'Æble, tørret':

select upper(food_name.name) from food_name

Result: ÆBLE, TøRRET
Expected result: ÆBLE, TØRRET

or

select lower(food_name.name) from food_name

Result: Æble, tørret
Expected result: æble, tørret

Case 2:
-------

Column 'name' contains 'æøå':

select upper(food_name.name) from food_name

Result: æøå
Expected result: ÆØÅ

Case 3:
-------

Column 'name' contains 'ÆØÅ':

select lower(food_name.name) from food_name

Result: ÆØÅ
Expected result: æøå

---

I can see I'm not alone with this kind of bug. This bug is really a big
problem for me.

I really don't want to replace PostgreSQL with MySQL !
Will this bug be fixed very soon?

Best regards

Kenneth Christensen

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match