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.