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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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



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

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 Serviço, and you use the lower function, the result is serviÇo, instead
of serviço. the other side is also true: if you use upper in the same eord,
the result is SERVIçO, instead of SERVIÇO.

select upper('Serviço');
Expected result: SERVIÇO
Actual result: SERVIçO

select lower('Serviço');
Expected result: serviço
Actual result: serviÇo



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group