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.