[DB] Database collation case-sensitive (資料行定序)

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