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

From: "Kenneth Christensen" <kec(at)mediatorsystems(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3378: UTF-8 upper() and lower() don't work
Date: 2007-06-10 09:48:45
Message-ID: 200706100948.l5A9mjlW012817@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 3378
Logged by: Kenneth Christensen
Email address: kec(at)mediatorsystems(dot)com
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, trret':

select upper(food_name.name) from food_name

Result: BLE, TRRET
Expected result: BLE, TRRET

or

select lower(food_name.name) from food_name

Result: ble, trret
Expected result: ble, trret

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Pavel Stehule 2007-06-10 13:36:15 Re: BUG #3378: UTF-8 upper() and lower() don't work
Previous Message Christian Gonzalez 2007-06-08 19:34:03 Re: BUG #3377: pg_dump: No matching tables were found