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

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

From: InterZone <info(at)interzone(dot)gr>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: info(at)interzone(dot)gr,PostgreSQL Bugs List <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #1069: functions "lower()" and "upper()" not characterset-aware
Date: 2004-01-28 19:41:51
Message-ID: 4018107F.1060806@interzone.gr (view raw or flat)
Thread:
Lists: pgsql-bugs
Tom Lane wrote:
> "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.

Well, ISO_8859_7 is not multi-byte, and you're right:
I had:
LC_COLLATE:                           C
LC_CTYPE:                             C

I tried
initdb -E ISO_8859_7 --locale=el_GR data1
and it all worked wonderfully.

> 
> 			regards, tom lane

Thanks a lot and sorry for the false alarm.
Regards
Interzone


In response to

pgsql-bugs by date

Next:From: Darcy BuskermolenDate: 2004-01-28 21:28:21
Subject: ERROR: invalid INTERVAL typmod: 0xc
Previous:From: Hamedany, AllenDate: 2004-01-28 16:29:49
Subject: FW: Can not always connect to postmaster. Sometimes get "Connection refused".

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