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
I'm a bit new to MySQL. I need to create a Memo field (a field that could
contain a lot of information). I know that in some languages, BLOB is a
Memo field. Is that the case with MySQL? If so, are there some parameters
that I need to use here, or should I use another type to represent my Memo
Message-
From: Jesse Castleberry [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 09, 2005 2:32 PM
To: MySQL List
Subject: Does BLOB=Memo?
I'm a bit new to MySQL. I need to create a Memo field (a field that could
contain a lot of information). I know that in some languages, BLOB is a
Memo
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