| C++ Type | ODBC | SQL Server | MySQL |
| bool | SQL_C_CHAR | bit(1), char(1) | TINYINT, BOOL |
| char | SQL_C_CHAR | char (1) | CHAR |
| signed char | SQL_C_CHAR | char (1) | CHAR |
| unsigned char | SQL_C_CHAR | char (1) | CHAR |
| short | SQL_C_SSHORT | smallint(2) | SMALLINT |
| unsigned short | SQL_C_USHORT | smallint(2) | SMALLINT UNSIGNED |
| int | SQL_C_SLONG | int (4) | INT |
| unsigned int | SQL_C_ULONG | int (4) | INT UNSIGNED |
| long | SQL_C_SLONG | int (4) | INT |
| unsigned long | SQL_C_ULONG | int (4) | INT UNSIGNED |
| float | SQL_C_FLOAT | real (4) | FLOAT |
| double | SQL_C_DOUBLE | float (8) | DOUBLE |
| std::string | SQL_C_CHAR | varchar(n),nchar(n) | VARCHAR(n), CHAR(n) |
| boost::posix_time::ptime | SQL_C_TIMESTAMP | datetime(8),smalldatetime(4) | DATETIME, TIMESTAMP |