Database Collation Flashcards
1
Q
CI/CS
A
Case Insensitive/Sensitive
2
Q
AI/AS
A
Accent Insensitive/Sensitive
3
Q
SC
A
Supplementary Characters
4
Q
WS
A
Width Sensitive (Full width/Half Width characters)
5
Q
KS
A
Kana Sensitive
6
Q
BIN
A
Sorts and compares data in SQL Server tables based on the bit patterns defined for each character
7
Q
BIN2
A
Sorts and compares data in SQL Server tables based on Unicode code points for Unicode data
8
Q
VSS
A
Variation Selector Sensitive
9
Q
UTF8
A
Enables UTF-8 encoded data to be stored in SQL Server
