{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 趁早两清 的问题《Microsoft Access memo datatype to MySQL Datatype》','https://www.manongdao.com/q-886913.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
What datatype in MySQL would be best to use for data that was in Memo on Microsoft Access?
相关问题
- SQL join to get the cartesian product of 2 columns
- sql execution latency when assign to a variable
- Difference between Types.INTEGER and Types.NULL in
- php PDO::FETCH_ASSOC doesnt detect select after ba
- sqlyog export query result as csv
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.
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
memofield.When in doubt
longtextwill hold up to 4GB.