doc.FAQ.WhatDoesUSEANSINullsPaddingAndWarningsDo

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.