The following table illustrates how driver maps the server data types to default SQL and C data types:
bit
SQL_BIT
SQL_C_BIT
tinyint
SQL_TINYINT
SQL_C_STINYINT
tinyint unsigned
SQL_C_UTINYINT
bigint
SQL_BIGINT
SQL_C_SBIGINT
bigint unsigned
SQL_C_UBIGINT
long varbinary
SQL_LONGVARBINARY
SQL_C_BINARY
blob
longblob
tinyblob
mediumblob
long varchar
SQL_LONGVARCHAR
SQL_C_CHAR
text
mediumtext
char
SQL_CHAR
numeric
SQL_NUMERIC
decimal
SQL_DECIMAL
integer
SQL_INTEGER
SQL_C_SLONG
integer unsigned
SQL_C_ULONG
int
int unsigned
mediumint
mediumint unsigned
smallint
SQL_SMALLINT
SQL_C_SSHORT
smallint unsigned
SQL_C_USHORT
real
SQL_FLOAT
SQL_C_DOUBLE
double
float
SQL_REAL
SQL_C_FLOAT
double precision
SQL_DOUBLE
date
SQL_DATE
SQL_C_DATE
time
SQL_TIME
SQL_C_TIME
year
SQL_C_SHORT
datetime
SQL_TIMESTAMP
SQL_C_TIMESTAMP
timestamp
SQL_VARCHAR
varchar
enum
set
bool