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

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: info(at)interzone(dot)gr
Cc: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #1069: functions "lower()" and "upper()" not characterset-aware
Date: 2004-01-28 15:19:48
Message-ID: 18599.1075303188@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org> writes:
> the functions "lower()" and "upper()" do not seem to work correctly with 
> ISO_8859_7 values 

> CREATE DATABASE mediagrk WITH TEMPLATE = template0 ENCODING = 'ISO_8859_7';

upper/lower are driven by the database locale, not the encoding.

They are presently broken for multi-byte encodings, but I don't think 
ISO_8859_7 is multi-byte.

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Hamedany, AllenDate: 2004-01-28 16:29:49
Subject: FW: Can not always connect to postmaster. Sometimes get "Connection refused".
Previous:From: PostgreSQL Bugs ListDate: 2004-01-28 10:30:24
Subject: BUG #1069: functions "lower()" and "upper()" not characterset-aware

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