> create table test (val varchar(10)); > insert into test values ('A'); > insert into test values ('a'); > select * from test where val < 'a'; > > Results on 8.0.1 linux server (UNICODE) > val > ----- > (0 rows) > > Results on 8.0.3 windows server (UNICODE) val > ----- > A > (1 row) > > I am guessing that the 8.0.3 on windows is the correct > version - but what changes this and how can I set it? UNICODE is not currently supported on win32. We hope to have this done in 8.1, but in 8.0 bad things like this will happen. See http://www.postgresql.org/docs/faqs.FAQ_windows.html#2.6. //Magnus ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster