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