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

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/