= doc.FAQ.WhatDoesUSEANSINullsPaddingAndWarningsDo

%TOC%


This affects the TDS agent & Lite Drivers but only for the Microsoft SQL Server database, not Sybase.

* When enabled, the agent issues the Transact-SQL commands below on connecting: 
{{{
SET ANSI_NULL_DFLT_ON ON
}}}

* When disabled, the agent issues the commands: 
{{{
SET ANSI_NULLS OFF 
SET ANSI_PADDING OFF 
SET ANSI_WARNINGS OFF 
SET CONCAT_NULL_YIELDS_NULL OFF
}}}


Refer to the Microsoft SQL Server Transact-SQL Reference at [[http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_tsqlcon_6lyk.asp.]]  

* **{{{SET ANSI_NULL_DFLT_ON}}}** - Affects the nullability of new columns when the nullability of the column is not specified in the {{{CREATE TABLE}}} and {{{ALTER TABLE}}} statements.
* **{{{SET ANSI_NULLS}}}** - Specifies SQL-92 compliant behavior of the Equal-To ({{{=}}}) and Not-Equal-To ({{{<>}}}) comparison operators when used with {{{NULL}}} values.  
* **{{{SET ANSI_PADDING}}}** - Controls the way the column stores values shorter than the defined size of the column, and the way the column stores values that have trailing blanks in {{{CHAR}}}, {{{VARCHAR}}}, {{{BINARY}}}, and {{{VARBINARY}}} data.  
* **{{{SET ANSI_WARNINGS}}}** - Specifies SQL-92 standard behavior for several error conditions.  
* **{{{SET CONCAT_NULL_YIELDS_NULL}}}** - Controls whether or not concatenation results are treated as null or empty string values.