Re: Does BLOB=Memo?
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 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 field? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Does BLOB=Memo?
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 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 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 field? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Does BLOB=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 Server Upscene Productions http://www.upscene.com Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]