Re: [Firebird-devel] [FB-Tracker] Created: (CORE-1172) Symbols ignored for ES_ES_CI_AI collation

[Adriano d. S. F. <adr...@uo...>]

Jorge Andrés Brugger wrote:
> Yes, it works fine putting collate just after field.
>
> My new question: Will it use the index? (STARTING WITH clause)
>
> I´m sure that select * from table where field starting with 'a' will use 
> the index by 'field', but select * from table where field collate 
> es_es_ci_ai starting with 'a' will?
>   
No.


Adriano