The core function of this syntax is to inform the database that the string should be processed using Unicode encoding (such as UTF-16), primarily for matching fields of Unicode types like NVARCHAR.

CSV files use a comma and Unicode Transformation Format (UTF) to share text between apps. UTF-8, UTF-16, and UTF=32 work better with specific apps.

While it may not look like much, the image above is a piece of the original email where [Ken Thompson] described what would become the implementation of UTF-8. At the dawn of the computer age in ...