Microsoft Access memo datatype to MySQL Datatype

2019-07-22 04:03发布

问题:

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

回答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.



回答2:

I believe that would be the TEXT type in MySQL you are looking for.

The equivalent on Microsoft SQL server would now be NVARCHAR(MAX) on newer versions, and NTEXT on older versions.