Error message:
Database collation must be case-sensitive and accent-sensitive. It is Latin1_General_CS_AI but should be Latin1_General_CS_AS.
Solution:
ALTER DATABASE [target_table_name] COLLATE Latin1_General_CS_AS;
Reference:
https://docs.microsoft.com/zh-tw/sql/relational-databases/collations/set-or-change-the-column-collation?view=sql-server-2017
https://docs.microsoft.com/zh-tw/sql/t-sql/statements/collation-precedence-transact-sql?view=sql-server-2017