UTF-16 Support in OLE DB Driver for SQL Server
Applies to:
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
Beginning in SQL Server 2012 (11.x), if you supply a fixed-length buffer when binding a column result or output parameter and if the wchar character written into the buffer before the terminating character is a high surrogate code point of a surrogate pair, and if the next wchar character is a low surrogate code point, OLE DB Driver for SQL Server will not add the high surrogate code point to the buffer.