Search code examples
mysqlsqlms-accesssqldatatypesmemo

Microsoft Access memo datatype to MySQL Datatype

What datatype in MySQL would be best to use for data that was in Memo on Microsoft Access?

Solution

  • TEXT would be a good match.

    Text is a blob field that is meant to store strings.
    blob is the same for binary data.

    See: http://dev.mysql.com/doc/refman/5.0/en/blob.html

    Make sure you use a text/blob variant that is large enough to hold the data that is currently in your memo field.
    When in doubt longtext will hold up to 4GB.