在下表中，介绍了驱动程序将服务器数据类型映射为默认SQL和C数据类型的方法：
|
值 |
SQL类型 |
C类型 |
|
bit |
SQL_BIT |
SQL_C_BIT |
|
tinyint |
SQL_TINYINT |
SQL_C_STINYINT |
|
tinyint unsigned |
SQL_TINYINT |
SQL_C_UTINYINT |
|
bigint |
SQL_BIGINT |
SQL_C_SBIGINT |
|
bigint unsigned |
SQL_BIGINT |
SQL_C_UBIGINT |
|
long varbinary |
SQL_LONGVARBINARY |
SQL_C_BINARY |
|
blob |
SQL_LONGVARBINARY |
SQL_C_BINARY |
|
longblob |
SQL_LONGVARBINARY |
SQL_C_BINARY |
|
tinyblob |
SQL_LONGVARBINARY |
SQL_C_BINARY |
|
mediumblob |
SQL_LONGVARBINARY |
SQL_C_BINARY |
|
long varchar |
SQL_LONGVARCHAR |
SQL_C_CHAR |
|
text |
SQL_LONGVARCHAR |
SQL_C_CHAR |
|
mediumtext |
SQL_LONGVARCHAR |
SQL_C_CHAR |
|
char |
SQL_CHAR |
SQL_C_CHAR |
|
numeric |
SQL_NUMERIC |
SQL_C_CHAR |
|
decimal |
SQL_DECIMAL |
SQL_C_CHAR |
|
integer |
SQL_INTEGER |
SQL_C_SLONG |
|
integer unsigned |
SQL_INTEGER |
SQL_C_ULONG |
|
int |
SQL_INTEGER |
SQL_C_SLONG |
|
int unsigned |
SQL_INTEGER |
SQL_C_ULONG |
|
mediumint |
SQL_INTEGER |
SQL_C_SLONG |
|
mediumint unsigned |
SQL_INTEGER |
SQL_C_ULONG |
|
smallint |
SQL_SMALLINT |
SQL_C_SSHORT |
|
smallint unsigned |
SQL_SMALLINT |
SQL_C_USHORT |
|
real |
SQL_FLOAT |
SQL_C_DOUBLE |
|
double |
SQL_FLOAT |
SQL_C_DOUBLE |
|
float |
SQL_REAL |
SQL_C_FLOAT |
|
double precision |
SQL_DOUBLE |
SQL_C_DOUBLE |
|
date |
SQL_DATE |
SQL_C_DATE |
|
time |
SQL_TIME |
SQL_C_TIME |
|
year |
SQL_SMALLINT |
SQL_C_SHORT |
|
datetime |
SQL_TIMESTAMP |
SQL_C_TIMESTAMP |
|
timestamp |
SQL_TIMESTAMP |
SQL_C_TIMESTAMP |
|
text |
SQL_VARCHAR |
SQL_C_CHAR |
|
varchar |
SQL_VARCHAR |
SQL_C_CHAR |
|
enum |
SQL_VARCHAR |
SQL_C_CHAR |
|
set |
SQL_VARCHAR |
SQL_C_CHAR |
|
bit |
SQL_CHAR |
SQL_C_CHAR |
|
bool |
SQL_CHAR |
SQL_C_CHAR |