SQL sets database attributes (case insensitive, accent, Kana, and width)

Alter database name collate chinese_prc_ci_as

 

For sql2005

1 right-click the database attribute
2 click, Option
3 sorting rules: Select chinese_prc_ci_as

========================

 

_ Bin binary sorting
_ Ci_ai is case-insensitive, stress-insensitive, Kana-insensitive, and width-insensitive
_ Ci_ai_ws are case-insensitive, Kana-insensitive, and width-aware.
_ Ci_ai_ks is case-insensitive, case-insensitive, Kana-type, and width-insensitive.
_ Ci_ai_ks_ws are case-insensitive, ks_ws are Kana-type, and width-aware.
_ Ci_as is case-insensitive, stress-sensitive, but not Kana type, and width-insensitive
_ Ci_as_ws is case-insensitive, stress-sensitive, and Kana-type.
_ Ci_as_ks is case-insensitive, stress-sensitive, Kana-type, and width-insensitive.
_ Ci_as_ks_ws are case-insensitive, stress-sensitive, and ks_ws are case-insensitive.
_ Cs_ai case sensitive, accent-insensitive, Kana-insensitive, and width-insensitive
_ Cs_ai_ws case-sensitive, stress-insensitive, Kana-type, and width-sensitive
_ Cs_ai_ks case sensitive, accent-insensitive, Kana type, and width-insensitive
_ Cs_ai_ks_ws case-sensitive, case-insensitive, Kana-type, and width-sensitive
_ Cs_as case sensitive, stress-sensitive, non-Kana type, and width-insensitive
_ Cs_as_ws case sensitive, stress sensitive, not Kana type, width differentiated
_ Cs_as_ks case sensitive, stress sensitive, Kana type, width insensitive
_ Cs_as_ks_ws case sensitive, stress sensitive, Kana type, and width sensitive