skip to main content
Part 2: The 32-Bit/64-Bit Drivers : The SQL Server Legacy Wire Protocol Driver : Connection Option Descriptions : AnsiNPW
  
AnsiNPW
Attribute
AnsiNPW
Purpose
Determines whether ANSI-defined behaviors are exposed.
Valid Values
yes | no
Behavior
When set to yes (Enabled), the driver uses ANSI-defined behaviors for handling NULL comparisons, character data padding, warnings, and NULL concatenation. If the driver appears to be truncating trailing blank spaces, this attribute should be set to no.
When set to no (Disabled), ANSI-defined behaviors are not exposed.
Default
yes (Enabled)
GUI Tab
n/a