On Nov 19, 2007 2:54 PM, Fabiano Bonin <fabianobonin@...> wrote:
> 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
>
> >
> >
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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