This question is definitely a duplicate of [SQL Server default collation vs database with different collation - potential problems?][1] However, as that question was purely generic and this question specifies the two collations, I can at least clarify one of the issues raised in that other question: > do you see any potential data loss? In this case there is no potential data loss due to the only difference being a sensitivity (accent sensitivity), which affects sorting and comparisons, but not which character set is being used to store `VARCHAR` data. [1]: https://dba.stackexchange.com/a/239937/30859