This defines how SQL Server will sort Case and Accents ( glyphs to determine pronunciation) and Kana (Japanese syllabic writing). Capitalization and the Diacritical ( Dia – through and krinein “to separate”) marks are included in sort considerations by SQL Server. Selecting the collation sequence on setup provide the Instance Collation however the collation can also be changed at the DB and Column level as well.
Key Words:
Collate > https://www.google.com/?gws_rd=ssl#q=define+collate and the derivation meaning “brought together”.
Code Page > https://en.wikipedia.org/wiki/Code_page
Vince Stefanetti