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

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group