c-treeACE V11.0 Release Notes

ODBC - SQLGetTypeInfo Returns Corrected Information

The following changes were made to SQLGetTypeInfo results:

• TIMESTAMP -

  Values COLUMN_SIZE, MINIMUM_SCALE, and MAXIMUM_SCALE were changed to reflect that fractional seconds are supported.

• TIME -

  Values COLUMN_SIZE, MINIMUM_SCALE, and MAXIMUM_SCALE were changed to reflect that fractional seconds are supported.

• LVARCHAR -

  Value COLUMN_SIZE was set to 2GB-1.

  CASE_SENSITIVE was changed to TRUE.

  SEARCHABLE was changed to SQL_UNSEARCHABLE.

• CLOB -

  Value COLUMN_SIZE, was set to 2GB-1.

  CASE_SENSITIVE was changed to TRUE.

  SEARCHABLE was changed to SQL_LIKE_ONLY based on the documented behavior.

  Note: The LVARCHAR data type is recommended for CLOB support.

• BINARY -

  Value COLUMN_SIZE was set to 8192.

• VARBINARY -

  Value COLUMN_SIZE was set to 8192.

• LVARBINARY -

  Value COLUMN_SIZE was set to 2GB-1.

  SEARCHABLE was changed to SQL_UNSEARCHABLE.

• BLOB -

  Value COLUMN_SIZE was set to 2GB-1.

  SEARCHABLE was changed to SQL_UNSEARCHABLE.

  Note: The LVARBINARY data type is recommended for BLOB support.