Microsoft Access memo datatype to MySQL Datatype

Question

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

Answer 1

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.