Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: BUG #1069: functions "lower()" and "upper()" not characterset-aware
Date
Msg-id 18599.1075303188@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1069: functions "lower()" and "upper()" not characterset-aware  ("PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>)
Responses Re: BUG #1069: functions "lower()" and "upper()" not characterset-aware
List pgsql-bugs
Tree view 
"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.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1069: functions "lower()" and "upper()" not characterset-aware
Next
From: Darcy Buskermolen
Date:
Subject: ERROR: invalid INTERVAL typmod: 0xc