skip to main content
Part 2: The 32-Bit/64-Bit Drivers : The SQL Server Wire Protocol Driver : Connection Option Descriptions : AnsiNPW
  
AnsiNPW
Attribute
AnsiNPW (ANPW)
Purpose
Determines whether ANSI-defined behaviors are exposed. Setting this option has no effect on NULL concatenation for Windows Azure SQL Database or SQL Server versions higher than SQL Server 2012.
Valid Values
0 | 1
Behavior
When set to 1 (Enabled), the driver sets four ANSI-defined behaviors for handling NULL comparisons: NULLS, character data padding, warnings, and NULL concatenation.
When set to 0 (Disabled), ANSI-defined behaviors are not exposed. If the driver appears to be truncating trailing blank spaces, set this attribute to 0 (Disabled).
Default
1 (Enabled)
GUI Tab
Advanced tab