Ask a question?
  • Contact Us
  • Support Case System
  • Support Forum

What Does USEANSINulls Padding And Warnings Do?

This affects the TDS agent & Lite Drivers but only the MS SQLServer 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

  • SET ANSI_NULL_DFLT_ON - Affects the null-ability of new columns when the null-ability of the column is not specified in the CREATE TABLE and ALTER TABLE statements.
  • SET ANSI_NULLS - Specifies SQL-92 compliant behavior of the Equals (=) 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.