It is used by the operating system to display and print a language properly. The code page defines 256 characters based on the 256 possible combinations in a single byte. For most code pages ...

Collation describes the code page, case sensitivity, accent sensitivity, and language or alphabet in use. This SQL Server tip illustrates how you can force the use of any specific collation.