This is interesting. If I create a new column and copy the data, the
problem is fixed and even using the old column the collate works.

On Nov 19, 2007 2:08 PM, Milan Babuskov <milanb@...> wrote:
> Erick Sasse wrote:
> > Setting index inactive and active also doesn't work.
>
> If you add another column and copy the data:
>
> update t1 set c_new = c_old;
>
> and then use the new column, does it work?
>
> --
> Milan Babuskov
> http://www.flamerobin.org
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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