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  for issues with code page on Windows console windows?
What kind of encoding are you using? I haven't reproduce your problem here.
Euler Taveira de Oliveira
In response to
pgsql-bugs by date
|Next:||From: Eduardo Ferreira||Date: 2007-05-31 03:10:31|
|Subject: Re: BUG #3323: Wrong charset for the lower and upper functions|
|Previous:||From: Pedro Gimeno Fortea||Date: 2007-05-30 21:30:50|
|Subject: Re: BUG #3319: Superuser can't revoke grants on a schema
given by aother user|