MDAC 2.5 SDK - ODBC Desktop Database Drivers


 

SQLColAttributes

Attribute Comments
SQL_COLUMN_DISPLAY_SIZE For LONGVARBINARY data, SQL_COLUMN_DISPLAY_SIZE is the maximum length of the column, not the maximum length of the column times 2.
SQL_OWNER_NAME An empty string ("") is returned in this column because owner name is not supported.
SQL_QUALIFIER_NAME The path to a database file is returned.
SQL_COLUMN_SEARCHABLE LONGVARBINARY and LONGVARCHAR columns are reported as SQL_UNSEARCHABLE.

Fixed-length and variable-length binary and character data types are searchable, even though LONGVARBINARY and LONGVARCHAR are not.


Note   The above is not a complete list of the attributes returned by SQLColAttributes.