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

Re: BUG #1478: Upper function does not work

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: Tiago Magalhães Vieira <tiago(dot)vieira(at)gmail(dot)com>,<pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #1478: Upper function does not work
Date: 2005-02-14 08:56:40
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE476877@algol.sollentuna.se (view raw or flat)
Thread:
Lists: pgsql-bugs
> Bug reference:      1478
> Logged by:          Tiago Magalhães Vieira
> Email address:      tiago(dot)vieira(at)gmail(dot)com
> PostgreSQL version: 8.0.0-rc5
> Operating system:   Windows XP
> Description:        Upper function does not work
> Details: 
> 
> I have been experiencing some problems with the uppercase 
> function, when the function has to make simple chars like 
> 'c','a' etc it returns them in uppercase, but when it has to 
> handle chars like 'á', 'é', 'ç' it does not do so. 
> 
> For example I have a field named 'med_type' in the table 
> 'test' and one of this data in the field 'med_type' is 
> 'Nutrição'. Then I make the query:
> 
> SELECT upper(med_type) FROM test;
> 
> It returns:
> 
> 'NUTRIçãO'
> 
> Even changed de characters enconding from UNICODE to ASCII 
> and the problem still happens.
> 
> Is this a bug or am I doing something wrong.

UNICODE is not supported on Win32.
ASCII does not know how to handle those characters.

You need to pick the correct encoding for these characters. Make sure you set the correct locale as well.

Also, you really should upgrade to the release version.

//Magnus

pgsql-bugs by date

Next:From: alagu madhuDate: 2005-02-14 10:21:08
Subject: BUG #1481: ERROR: type tablename does not exist
Previous:From: Tom LaneDate: 2005-02-14 06:52:22
Subject: Re: Bug in ALTER LANGUAGE ... RENAME TO ...;

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