Data Type Restrictions

This section lists size and format restrictions for data types.

Size Restrictions

The ODBC Extension has a size restriction of 1,048,576 bytes when processing the following data types:

  • IMAGE
  • TEXT
  • VARBINARY
  • VARBINARY(MAX)
  • VARCHAR(MAX)
  • XML

Format Restrictions

The ODBC Extension has a format restriction for field content that use the DATETIME or SMALLDATETIME data type for Data Subset Extraction: Data Subset Extraction rules must be specified using the format as documented by Microsoft.