You will need to alter every column in every table to match the new collation, then alter every table, then alter the database

Or

Create a new DB with the right collation, create all the tables in the new DB then transfer the data

The article will help you complete what you need to do for point 1.