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.