Thread: BUG #1576: Function UPPER does not give back the awaited results

The following bug has been logged online:

Bug reference:      1576
Logged by:          Sergio Luis Sánchez
Email address:      sluis@tissat.es
PostgreSQL version: 7.4.3 and 8.0.1
Operating system:   linux (7.4.3) and WinXP (8.0.1)
Description:        Function UPPER does not give back the awaited results
Details:

Hi.

I'm from Spain, and I am using a PostgreSQL as database system. Sorry for my
English.

I launch a select with the upper function to retrieve a text in capital
letters. When I launch the function to text with accents (Usual in Spanish
language), I get the marked words in lowercase, and it's wrong.

To test it I launh this query:

select upper('aeiouáéíóúàèìòù');

And the result was: "AEIOUáéíóúàèìòù", when it must be
"AEIOUÁÉÍÓÚÀÈÌÒÙ".

I try this function with UNICODE and LATIN1 encodings, and I retrieve same
result.

I reproduce the error in this two versions of Postgres:
- PostgreSQL 7.4.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3
20030502 (Red Hat Linux 3.2.3-24)
- PostgreSQL 8.0.1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(mingw-special)

NOTE: lower function fails too with marked words.

Thanks in advance

PkJ1ZyByZWZlcmVuY2U6ICAgICAgMTU3Ng0KPkxvZ2dlZCBieTogICAgICAg
ICAgU2VyZ2lvIEx1aXMgU8ODwqFuY2hleg0KPkVtYWlsIGFkZHJlc3M6ICAg
ICAgc2x1aXNAdGlzc2F0LmVzDQo+UG9zdGdyZVNRTCB2ZXJzaW9uOiA3LjQu
MyBhbmQgOC4wLjENCj5PcGVyYXRpbmcgc3lzdGVtOiAgIGxpbnV4ICg3LjQu
MykgYW5kIFdpblhQICg4LjAuMSkNCj5EZXNjcmlwdGlvbjogICAgICAgIEZ1
bmN0aW9uIFVQUEVSIGRvZXMgbm90IGdpdmUgYmFjayB0aGUgDQo+YXdhaXRl
ZCByZXN1bHRzDQo+RGV0YWlsczogDQo+DQo+SGkuIA0KPg0KPkknbSBmcm9t
IFNwYWluLCBhbmQgSSBhbSB1c2luZyBhIFBvc3RncmVTUUwgYXMgZGF0YWJh
c2UgDQo+c3lzdGVtLiBTb3JyeSBmb3IgbXkNCj5FbmdsaXNoLg0KPg0KPkkg
bGF1bmNoIGEgc2VsZWN0IHdpdGggdGhlIHVwcGVyIGZ1bmN0aW9uIHRvIHJl
dHJpZXZlIGEgdGV4dCBpbiBjYXBpdGFsDQo+bGV0dGVycy4gV2hlbiBJIGxh
dW5jaCB0aGUgZnVuY3Rpb24gdG8gdGV4dCB3aXRoIGFjY2VudHMgDQo+KFVz
dWFsIGluIFNwYW5pc2gNCj5sYW5ndWFnZSksIEkgZ2V0IHRoZSBtYXJrZWQg
d29yZHMgaW4gbG93ZXJjYXNlLCBhbmQgaXQncyB3cm9uZy4NCj4NCj5UbyB0
ZXN0IGl0IEkgbGF1bmggdGhpcyBxdWVyeToNCj4NCj5zZWxlY3QgdXBwZXIo
J2FlaW91w4PCocODwqnDg8Ktw4PCs8ODwrrDg8Kgw4PCqMODwqzDg8Kyw4PC
uScpOw0KPg0KPkFuZCB0aGUgcmVzdWx0IHdhczogIkFFSU9Vw4PCocODwqnD
g8Ktw4PCs8ODwrrDg8Kgw4PCqMODwqzDg8Kyw4PCuSIsIHdoZW4gaXQgbXVz
dCBiZQ0KPiJBRUlPVcODwoHDg+KAsMODwo3Dg+KAnMODxaHDg+KCrMODy4bD
g8WSw4PigJnDg+KEoiIuDQo+DQo+SSB0cnkgdGhpcyBmdW5jdGlvbiB3aXRo
IFVOSUNPREUgYW5kIExBVElOMSBlbmNvZGluZ3MsIGFuZCBJIA0KPnJldHJp
ZXZlIHNhbWUgcmVzdWx0Lg0KDQpJdCBzaG91bGRuJ3Qgd29yayBpbiBVTklD
T0RFIC0gc2VlIGh0dHA6Ly9wZ2luc3RhbGxlci5wcm9qZWN0cy5wb3N0Z3Jl
c3FsLm9yZy9GQVFfd2luZG93cy5odG1sIzIuNi4NCg0KSXQgc2hvdWxkIHdv
cmsgaW4gTEFUSU4xIHRob3VnaC4gSSd2ZSBuZXZlciBoYWQgYW55IHByb2Js
ZW1zIHdpdGggdGhhdCBwYXJ0ICh1c2UgaXQgZm9yIHN3ZWRpc2ggY2hhcnMg
YWxsIHRoZSB0aW1lKS4gTWFrZSBzdXJlIHlvdSByZWFsbHkgc3dpdGNoZWQg
dGhlIHNlcnZlciBzaWRlIGVuY29kaW5nIChuZXcgaW5pdGRiKSwgYW5kIG5v
dCBqdXN0IHRoZSBjbGllbnQgc2lkZS4NCg0KLy9NYWdudXMNCg==