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/ ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
