Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #3323: Wrong charset for the lower and upper functions - Mailing list pgsql-bugs

From Euler Taveira de Oliveira
Subject Re: BUG #3323: Wrong charset for the lower and upper functions
Date
Msg-id 465E3913.8000208@timbira.com
Whole thread Raw
In response to BUG #3323: Wrong charset for the lower and upper functions  ("Eduardo Santos" <eduardo.edusantos@gmail.com>)
Responses Re: BUG #3323: Wrong charset for the lower and upper functions
List pgsql-bugs
Tree view 
Eduardo Santos wrote:

> 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.
>
Did you read [1] for issues with code page on Windows console windows?
What kind of encoding are you using? I haven't reproduce your problem here.

[1] http://www.postgresql.org/docs/8.2/static/app-psql.html

--
  Euler Taveira de Oliveira
  http://www.timbira.com/

pgsql-bugs by date:

Previous
From: Pedro Gimeno Fortea
Date:
Subject: Re: BUG #3319: Superuser can't revoke grants on a schema given by aother user
Next
From: "Eduardo Ferreira"
Date:
Subject: Re: BUG #3323: Wrong charset for the lower and upper functions