How SQL Server Stores Strings: varchar, nvarchar, and What UTF-8 Changed

· by · in

The same word can take 3, 5, 6, or 9 bytes depending on the type and collation. A byte-level look at varchar, nvarchar, and UTF-8 collations.