Documentation

This is machine translation

Translated by Microsoft
Mouseover text to see original. Click the button below to return to the English verison of the page.

Note: This page has been translated by MathWorks. Please click here
To view all translated materals including this page, select Japan from the country navigator on the bottom of this page.

Data Type Support

You can import these data types into the MATLAB® workspace and export them back to your database.

DatabaseSupported Data Type

All databases

  • BOOLEAN

  • CHAR

  • DATE

  • DECIMAL

  • DOUBLE

  • FLOAT

  • INTEGER

  • NUMERIC

  • REAL

  • SMALLINT

  • TIME

  • TIMESTAMP

    Note

    When importing TIMESTAMP data into MATLAB, you can get an incorrect value at the daylight savings time change. To avoid an incorrect value, convert TIMESTAMP data to strings in your SQL query. Then, convert the strings back to the MATLAB data type you want. Or, connect to your database using a different driver.

Microsoft® SQL Server®

  • NTEXT

  • TEXT

  • VARCHAR(MAX)

  • CHAR(8000)

  • NCHAR(4000)

  • NVARCHAR(MAX)

  • TINYINT

MySQL®

  • MEDIUMTEXT

  • LONGTEXT

  • TINYINT

Oracle®

  • LONG

  • VARCHAR2(4000)

  • NCHAR(2000)

  • NVARCHAR2(4000)

To import data of another data type, manipulate the data before importing it into the MATLAB workspace. For details, see your database documentation.

See Also

| | | | |

Related Topics

Was this topic helpful?