> I've changed a field collate, but it only "worked" after a backup and restore.
> So is it really required to backup and restore the database when a
> collate is changed?

Have you rebuild affected indexes ?

Ivan P.