The following bug has been logged online: Bug reference: 1069 Logged by: Interzone
Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: Linux 2.4.24 Description: functions "lower()" and "upper()" not characterset-aware Details: the functions "lower()" and "upper()" do not seem to work correctly with ISO_8859_7 values Test case: CREATE DATABASE mediagrk WITH TEMPLATE = template0 ENCODING = 'ISO_8859_7'; CREATE TABLE test1 ( code serial NOT NULL, compname character varying(100) NOT NULL ); INSERT INTO test1 VALUES (1, 'ΕΛΛΗΝΙΚΑ'); SELECT lower(compname) from test1; if there is a problem (there might be) with the greek characters above, just remember that this is a iso-8859-7 encoded text (and I changed the encoding of the form-page to iso-8859-7 before sending). ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
