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.