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