Controls how the SQL Anywhere ODBC driver describes CHAR columns.
On, Off
Off
When a connection is opened, the SQL Anywhere ODBC driver uses the setting of this option to determine how CHAR columns are described. If this option 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.
The odbc_distingish_char_and_varchar option also controls whether NCHAR columns are described as SQL_WCHAR or SQL_WVARCHAR. If this option is set to Off, then NCHAR columns are described as SQL_WVARCHAR. If this option is set to On, then NCHAR columns are described as SQL_WCHAR. NVARCHAR columns are always described as SQL_WVARCHAR.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |