I ran the same tests in SQL Server 2008R2, Oracle10 and PostgreSQL 9.0.4 and found something interesting... results ===== SQL Server 2008 R2 (with case insensitive data, the ordering follows ASCII order) Oracle 10 (data is case-sensitive, the ordering follows ASCII order) PostgreSQL 9.0.4 (data is case-sensitive, the ordering is ... DIFFERENT)
perhaps http://www.postgresql.org/docs/9.1/static/charset.html will provide an answer