Tom Lane wrote:
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
