The following table shows how the Btrieve data types map to the standard ODBC data types. The Btrieve data types are used when you incorporate Btrieve files into a Scalable SQL database.

Table 1. Btrieve Data Types
Btrieve ODBC
Autoincrement(2) SQL_SMALLINT
Autoincrement(4) SQL_INTEGER
Bfloat(4) SQL_REAL
Bfloat(8) SQL_DOUBLE
Bit SQL_BIT
Blob SQL_LONGVARGBINARY
Char SQL_CHAR
Currency SQL_DECIMAL
Date SQL_TYPE_DATE
Decimal SQL_DECIMAL
Float(4) SQL_REAL
Float(8) SQL_DOUBLE
Integer(1) SQL_TINYINT
Integer(2) SQL_SMALLINT
Integer(4) SQL_INTEGER
Integer(8) SQL_BIGINT
Logical(1) SQL_BIT
Logical(2) SQL_BIT
Lstring SQL_VARCHAR
Money SQL_DECIMAL
Note SQL_LONGVARCHAR
Numeric SQL_NUMERIC
Numericsts SQL_NUMERIC
Time SQL_TYPE_TIME
Timestamp SQL_TYPE_TIMESTAMP
Unsigned(1) SQL_TINYINT
Unsigned(8) SQL_BIGINT
Zstring SQL_VARCHAR

See Retrieving Data Type Information for information about retrieving data types.