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

BUG #3323: Wrong charset for the lower and upper functions

From: "Eduardo Santos" <eduardo(dot)edusantos(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3323: Wrong charset for the lower and upper functions
Date: 2007-05-30 19:40:54
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      3323
Logged by:          Eduardo Santos
Email address:      eduardo(dot)edusantos(at)gmail(dot)com
PostgreSQL version: 8.2.4
Operating system:   Windows
Description:        Wrong charset for the lower and upper functions

When you have the latin character  and use the lower or the upper
function, instead of return the approprite character, it returns the oposite
one, so the comparisons in the whole DB are wrong. If you have a word such
as Servio, and you use the lower function, the result is servio, instead
of servio. the other side is also true: if you use upper in the same eord,
the result is SERVIO, instead of SERVIO.

select upper('Servio');
Expected result: SERVIO
Actual result: SERVIO

select lower('Servio');
Expected result: servio
Actual result: servio


pgsql-bugs by date

Next:From: Frank van VugtDate: 2007-05-30 19:46:16
Subject: Re: backend crash with FATAL: BeginInternalSubTransaction: unexpected state END
Previous:From: Pedro Gimeno ForteaDate: 2007-05-30 18:55:22
Subject: Re: BUG #3319: Superuser can't revoke grants on a schema given by aother user

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