ODBC_DISTINGUISH_CHAR_AND_VARCHAR option

Function

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

Allowed values

ON, OFF

Default

OFF

Description

When a connection is opened, the Sybase IQ and SQL 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 3, “SQL Data Types” in Reference: Building Blocks, Tables, and Procedures