MySQL

The supported OpenDB data types when using a MySQL database are described below.

MySQL Data Type	Supported by OpenDB	Comments
bit	Yes
tinyint	Yes
smallint	Yes
mediumint	Yes
int	Yes
integer	Yes
bigint	Yes
real	Yes
double	Yes
float	Yes
decimal	Yes
numeric	Yes
date	Yes
time	Yes
timestamp	Yes
year	Yes
char	Yes
varchar	Yes
binary	No
varbinary	No
tinyblob	No
mediumblob	No
longblob	No
tinytext	Yes	Uses ODBC SQL_LONGVARCHAR(255)
text	Yes	Uses ODBC SQL_LONGVARCHAR Up to 'maxcolsize' value Default is 4096 Change with /maxcolsize command line option
mediumtext	Yes	Uses ODBC SQL_LONGVARCHAR Up to 'maxcolsize' value Default is 4096 Change with /maxcolsize command line option
longtext	Yes	Uses ODBC SQL_LONGVARCHAR Up to 'maxcolsize' value Default is 4096 Change with /maxcolsize command line option
enum	Yes
set	Yes