Subject | Case sort order/collation order related? |
---|---|
Author | Jorge Andrés Brugger |
Post date | 2004-05-10T19:17:16Z |
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
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