On Jul 22, 12:20 pm, scott_r...@elevated-dev.com (Scott Ribe) wrote: > On Jul 22, 2011, at 11:11 AM, Samuel Hwang wrote: > > > results > > ===== > > SQL Server 2008 R2 (with case insensitive data, the ordering follows > > ASCII order) > > > f1 > > --- > > AbC > > abc > > ABc > > cde > > CdE > > Well, if it's case insensitive, then AbC & abc & ABc are all equal, so any > order for those 3 would be correct... > > -- > Scott Ribe > scott_r...@elevated-dev.comhttp://www.elevated-dev.com/ > (303) 722-0567 voice > > -- > Sent via pgsql-general mailing list (pgsql-gene...@postgresql.org) > To make changes to your > subscription:http://www.postgresql.org/mailpref/pgsql-general
Sorry I didn't make it clear, the interesting part is how PostgreSQL sorts data. The server encoding is set to UTF8 and collation is united states.1252 The client encoding is Unicode. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
