SQL Server Collation

1.

viewing collations

Select SERVERPROPERTY (' collation ');

2.

Specifying the collation of a column

ALTER TABLE T2
Add Y nvarchar (+) collate chinese_prc_ci_as;
Go

---------------------------------------------------

Chinese---The meaning of "body word" "Chinese".
Chinese "PRC refers to People's Republic of China---The People's Republic of China.

CHINESE_PRC---Simplified Chinese

CI (CS): Is case-sensitive, CI is not differentiated, CS is differentiated.
Ai (AS): whether accent-sensitive, AI is not differentiated, as is differentiated.
Ki (KS): Whether the kana type is differentiated, Ki does not differentiate, KS differentiates.
WI (WS): Whether width-sensitive wi is not differentiated, WS differentiates.

---------------------------------------------------

SQL Server Collation