Subject Case sort order/collation order related?
Author Jorge Andrés Brugger
Hi all.
I´ve a database, and a varchar field. I´ve created an index by the
varchar field, all using ISO8859_1. Now, if I do a 'select * from Table
order by VarChatField', 'AB' is ordered first than 'Aa' and for me this
is wrong. I´ve changed the collation order of the field to ES_ES with
same results ... how can I obtain a right-sorted result set? I need 'Aa'
before 'AB'.

Thanks!

--

Jorge Andrés Brugger
DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia
Comodoro Rivadavia, Chubut, Argentina
Correo electrónico: jbrugger@...
Website: www.dasu.com.ar