It depends, BLOB you can store just about anything in, like a
document or an image. If you just want to store lots of text, then
use the TEXT type.
On Nov 9, 2005, at 2:32 PM, Jesse Castleberry wrote:
I'm a bit new to MySQL. I need to create a Memo field (a field
that could
contain a
Access MEMO is actually closer to LONGTEXT than to BLOB.
Blob stands for Binary Large OBject.
Although you can use BLOB, depending on what you are inserting, it is
recommended that you use LONGTEXT for your memo field.
J.R.
http://dev.mysql.com/doc/refman/5.0/en/blob.html
-Original
Access MEMO is actually closer to LONGTEXT than to BLOB.
Blob stands for Binary Large OBject.
No it doesn't ... Ok, it does now :-)
http://www.cvalde.net/misc/blob_true_history.htm
;-)
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle MS SQL