RE: [PHP] SQL Query Statement for MySQL... (DataType --> TEXT vs BLOB)

Probably a good question for a MySQL e-mail list. > [Original Message] > From: Scott Fletcher <scott@abcoa.com> > To: <php-general@lists.php.net> > Date: 06/10/2004 12:49:07 PM > Subject: [PHP] SQL Query Statement for MySQL... (DataType --> TEXT vs BLOB) > > I'm wrestling over deciding on which data type to go with, TEXT or BLOB. I > have one table with one column of 400 characters, I was thinking that TEXT > may be the way to go for that one. > > I also have another table that use 4 columns of 800 characters along with 5 > columns that use 250 characters. I'm thinking of using TEXT for 9 of those > columns. > > The reason is because I read the MySQL Manual there that say TEXT and BLOB > are pretty much the same in many ways, the only thing different is that BLOB > use "VARCHAR" Binary while TEXT use "VARCHAR". But reading the article > somewhere (not part of MySQL's Manual) say this... > > --snip-- > If it doesn't have to be searchable then a BLOB might be more efficient and > you shouldn't have to worry about size (Like size is important? ). The > reason being that BLOB information is stored seperate from the table data > and is related by a reference number in the table. This keeps the table > smaller and faster as I understand. > --snip-- > > So, I don't feel too sure what to decide on... Care for some advice or > recommendation?? > > Thanks, > Scott Fletcher > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php