VORTEX_ODBC_CHAR
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