B.1.3 Character Types

A new option on the Advanced tab of the AcuODBC Configuration property sheet enables you to indicate how AcuODBC should treat character data. Values you can indicate are:

Mixed Treat character data as in previous versions (to maintain compatibility). Report the column as SQL_CHAR, but remove trailing spaces (as if it were SQL_VARCHAR).
CHAR Report the column as SQL_CHAR type and do not remove trailing spaces.
VARCHAR Report the column as SQL_VARCHAR and remove trailing spaces.

This is of particular importance to users of SQL Server. See Chapter 3 for additional information.

Mixed	Treat character data as in previous versions (to maintain compatibility). Report the column as SQL_CHAR, but remove trailing spaces (as if it were SQL_VARCHAR).
CHAR	Report the column as SQL_CHAR type and do not remove trailing spaces.
VARCHAR	Report the column as SQL_VARCHAR and remove trailing spaces.