> I just tried to find an easy way but at the same time I do not want to get any problem later so I will do things the correct way
> by creating a new empty database file with the correct collation then transfering all my data.

Or use the officially supported way - ALTER TABLE commands.
You do not have to write them by hand, just generated them by reading system tables.