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

Tom Lane wrote:
> "PostgreSQL Bugs List" <pgsql-bugs@postgresql.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