Collation and Unicode Support. 04/23/2019; 19 minutes to read; ... Collations that are used with character data types such as char and varchar dictate the code page and corresponding characters that can be represented for that data type. Whether you are installing a new instance of SQL Server, restoring a database backup, or connecting server ...