Hi,

> 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'.

Collation DU_NL will do this, but this could have another wrong sorting for
your country.

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Interbase and Firebird users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://80.126.130.81