UTF-16 Support in SQL Server Native Client 11.0

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)

Important

SQL Server Native Client (SNAC) isn't shipped with:

  • SQL Server 2022 (16.x) and later
  • SQL Server Management Studio 19 and later

The SQL Server Native Client (SQLNCLI or SQLNCLI11) and the legacy Microsoft OLE DB Provider for SQL Server (SQLOLEDB) are not recommended for new application development.

For new projects, use one of the following drivers:

For SQLNCLI that ships as a component of SQL Server Database Engine (versions 2012 through 2019), see this Support Lifecycle exception.

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, SQL Server Native Client will not add the high surrogate code point to the buffer.

See Also

SQL Server Native Client Features