Microsoft Access备注数据类型转换为MySQL数据类型 [英] Microsoft Access memo datatype to MySQL Datatype

问题描述

MySQL中哪种数据类型最适合用于Microsoft Access备忘录中的数据?

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

推荐答案

TEXT是很好的匹配.

TEXT would be a good match.

文本是用于存储字符串的Blob字段.
blob对于二进制数据是相同的.

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

请参阅: http://dev.mysql.com/doc/refman/5.0/en/blob.html

请确保使用足够大的text/blob变体来容纳memo字段中当前的数据.
如有疑问，longtext最多可容纳4GB.

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.

这篇关于Microsoft Access备注数据类型转换为MySQL数据类型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！