VORTEX_ODBC_CHAR

ODBC string descriptions

WTSupported in traditional Synergy on Windows
WNSupported in Synergy .NET on Windows
USupported on UNIX
VSupported on OpenVMS

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

Value

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)

Discussion

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.

Setting location

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.)

Used by

xfODBC.

See also

Changing the way xfODBC describes strings.

Examples

VORTEX_ODBC_CHAR=12