You'll need to drop the FULLTEXT index first before changing their members' collation. then redo the index. Make sure you note how to recreate said indexes before blowing them away :).
Colton Smith wrote: > > Hi > > As suggested by Matt, I consulted http://laconi.ca/trac/ticket/776 > . Indeed, when I made the indicated changes to the notice table, the > text search works as expected. > > But I wasn't able to change the collation on columns nickname or > fullname of the profile table. Does anybody have the same problem? > > Your help is greatly appreciated! > > ------------------------------------------------------------------------ > > _______________________________________________ > Laconica-dev mailing list > [email protected] > http://mail.laconi.ca/mailman/listinfo/laconica-dev > -- Mark Keisler Principal Software Engineer Motorola Open Source Technologies 630-329-2828 _______________________________________________ Laconica-dev mailing list [email protected] http://mail.laconi.ca/mailman/listinfo/laconica-dev
