Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group