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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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