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

From: Euler Taveira de Oliveira <euler(at)timbira(dot)com>
To: Eduardo Santos <eduardo(dot)edusantos(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3323: Wrong charset for the lower and upper functions
Date: 2007-05-31 02:55:15
Message-ID: 465E3913.8000208@timbira.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Eduardo Ferreira 2007-05-31 03:10:31 Re: BUG #3323: Wrong charset for the lower and upper functions
Previous Message Pedro Gimeno Fortea 2007-05-30 21:30:50 Re: BUG #3319: Superuser can't revoke grants on a schema given by aother user