SQL_DESC_CASE_SENSITIVE

ODBC Driver for Teradata® User Guide

prodname
ODBC Driver for Teradata
vrm_release
16.20
category
User Guide
featnum
B035-2526-108K

The SQL_DESC_CASE_SENSITIVE descriptor record field contains SQL_TRUE if the column or parameter is treated as case-sensitive for collations and comparisons or if it is a noncharacter column.

When extended statement information is not available, the value of the SQL_DESC_CASE_SENSITIVE descriptor field will always be SQL_TRUE for a character column, regardless of the column definition (“CASESPECIFIC” or “NOT CASESPECIFIC”).

When extended statement information is available, the value of the SQL_DESC_CASE_SENSITIVE descriptor field matches the column definition; for example, the value is SQL_TRUE if the column is defined as “CASESPECIFIC” and the value is SQL_FALSE if the column is defined as “NOT CASESPECIFIC”.