Ok, I didn't try that but what about fields that doesn't have indexes?
It doesn't work either. If the problem is the index, shouldn't it work
just after changing the collate?

On Nov 19, 2007 1:41 PM, Ivan Prenosil <Ivan.Prenosil@...> wrote:
> > Yes, I've tried using "SET STATISTICS" and even drop and recreate the
> > index didn't work.
>
> Set index Inactive and Active will rebuild it, then you probably need to reconnect
> (ensure that all users are disconnected so that metadata cache is cleared)
>
>
> Ivan P.
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>



--
Erick Sasse