Database Toolbox

Structured Query Language (SQL)

The Database Toolbox supports American National Standards Institute (ANSI) standard SQL commands.

Data Types

You can import the following data types into MATLAB and export them back to your database:

• BOOLEAN
• CHAR
• DATE
• DECIMAL
• DOUBLE
• FLOAT
• INTEGER
• LONGCHAR (This is called the Memo data type in Microsoft Access.)
• NUMERIC
• REAL
• SMALLINT
• TIME
• TIMESTAMP
• TINYINT
• VARCHAR

Any other type of data that is imported is treated as a VARCHAR by MATLAB. If you import a data type that cannot be treated as a VARCHAR, you see an unsupported data message from MATLAB.

If you try to export MATLAB data types not on this list, you see a syntax error from the database.

Drivers

Installing the Database Toolbox