skip to main content
Connection Option Descriptions : AnsiNPW
  

Try DataDirect Drivers Now

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