I assume the issue your trying to avoid is the sort order problem with unicode as mentioned in the below link.

http://www.olcot.co.uk/sql-blogs/revised-difference-between-collation-sql_latin1_general_cp1_ci_as-and-latin1_general_ci_as

else there should be little need to change the collation in the first place.