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

BUG #1478: Upper function does not work

From: "Tiago Magalhes Vieira" <tiago(dot)vieira(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1478: Upper function does not work
Date: 2005-02-11 20:40:06
Message-ID: 20050211204006.1333EF0B21@svr2.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1478
Logged by:          Tiago Magalhes 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 'Nutrio'. Then I make the query:

SELECT upper(med_type) FROM test;

It returns:

'NUTRIO'

Even changed de characters enconding from UNICODE to ASCII and the problem
still happens.

Is this a bug or am I doing something wrong.

Thanks in advance.

pgsql-bugs by date

Next:From: Brian B.Date: 2005-02-11 22:13:36
Subject: Re: BUG #1473: Backend bus error, possibly due to ANALYZE
Previous:From: Hans-Jürgen SchönigDate: 2005-02-11 18:35:53
Subject: Re: BUG #1476: on Xeon 2.8 can't instaling source

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