Database Collation Flashcards Preview

70-464 Certification > Database Collation > Flashcards

Flashcards in Database Collation Deck (9)
Loading flashcards...
1

CI/CS

Case Insensitive/Sensitive

2

AI/AS

Accent Insensitive/Sensitive

3

SC

Supplementary Characters

4

WS

Width Sensitive (Full width/Half Width characters)

5

KS

Kana Sensitive

6

BIN

Sorts and compares data in SQL Server tables based on the bit patterns defined for each character

7

BIN2

Sorts and compares data in SQL Server tables based on Unicode code points for Unicode data

8

VSS

Variation Selector Sensitive

9

UTF8

Enables UTF-8 encoded data to be stored in SQL Server