Arno:

Can I check the collation order ES_ES is somewhere? It´s 'fixable'? Or
even better, change the ISO8859_1 collation would be great, so I don
need to specify the collation in order by, group by, etc.

TIA

Arno Brinkman wrote:

>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
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>

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



[Non-text portions of this message have been removed]