Erick, try it after change the collation:

update table set column = column;

If i'm not mistaken, this will solve your problem.

Regards,

Fabiano.

On Nov 19, 2007 1:30 PM, Erick Sasse <esasse@...> wrote:
>
>
>
>
>
>
> 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
>
>