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

BUG #1069: functions "lower()" and "upper()" not characterset-aware

From: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1069: functions "lower()" and "upper()" not characterset-aware
Date: 2004-01-28 10:30:24
Message-ID: (view raw or whole thread)
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1069
Logged by:          Interzone

Email address:      info(at)interzone(dot)gr

PostgreSQL version: 7.4

Operating system:   Linux 2.4.24

Description:        functions "lower()" and "upper()" not characterset-aware


the functions "lower()" and "upper()" do not seem to work correctly with 
ISO_8859_7 values 

Test case:
CREATE DATABASE mediagrk WITH TEMPLATE = template0 ENCODING = 'ISO_8859_7';
   code serial NOT NULL,
   compname character varying(100) NOT NULL
INSERT INTO test1 VALUES (1, '');
SELECT lower(compname) from test1;

if there is a problem (there might be) with the greek characters above, just 
remember that this is a iso-8859-7 encoded text (and I changed the encoding 
of the form-page to iso-8859-7 before sending). 


pgsql-bugs by date

Next:From: Tom LaneDate: 2004-01-28 15:19:48
Subject: Re: BUG #1069: functions "lower()" and "upper()" not characterset-aware
Previous:From: Tom LaneDate: 2004-01-27 16:58:39
Subject: Re: PgSQL Down

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