VORTEX_ODBC_CHAR

ODBC string descriptions

WSupported on Windows
USupported on Unix
VSupported on OpenVMS
NSupported in Synergy .NET

The VORTEX_ODBC_CHAR environment variable determines how strings are passed and described.

One of the following values:

1 = Pass strings as SQL_VARCHAR but describe them as SQL_CHAR.

12 = Pass and describe strings as SQL_VARCHAR. (default)

Some applications, such as Microsoft Data Transformation Services (DTS), require strings to be passed as they are described, which is the ODBC standard. By default, however, the xfODBC driver passes strings as SQL_VARCHAR (that is, with trailing spaces removed), but describes them as SQL_CHAR.

VORTEX_ODBC_CHAR is used by the xfODBC driver when it sends data to the application. It does not affect the way system catalogs are generated.

The system environment. For client/server configurations, VORTEX_ODBC_TIME must be set on the client. (For a service, such as IIS or SQL Server, you must reboot after setting VORTEX_ODBC_TIME.)

xfODBC

Changing the way xfODBC describes strings

VORTEX_ODBC_CHAR=12