ODBC_DISTINGUISH_CHAR_AND_VARCHAR option

Function

Controls how the Sybase IQ and Adaptive Server Anywhere ODBC driver describes CHAR columns.

Allowed values

ON, OFF

Default

OFF

Description

When a connection is opened, the Sybase IQ and Adaptive Server Anywhere ODBC driver uses the setting of this option to determine how CHAR columns are described. If ODBC_DISTINGUISH_CHAR_AND_VARCHAR is set to OFF (the default), then CHAR columns are described as SQL_VARCHAR. If this option is set to ON, then CHAR columns are described as SQL_CHAR. VARCHAR columns are always described as SQL_VARCHAR.

See also

Chapter 4, “SQL Data Types” in Sybase IQ Reference Manual.