Skip navigation links

MySQL Forums :: General :: LONGBLOB and LONGTEXT


Advanced Search

LONGBLOB and LONGTEXT
Posted by: Zsolt Kendi ()
Date: July 21, 2009 04:31AM

I found some garbled information about LONGBLOB and LONGTEXT (MYSQL 5.1).
At the limit I read the max row size is 65535. The LONGxxxx tell he's limit is more gigabyte. Somebody tell the LONGxxxx stored in one row. This information is inconsistent for me...
Some forum tell the BLOB and TEXT type stored separately from row.

Q1: Where (how) stored LONGTEXT or LONGBLOB?
Q2: Where (how) stored MEDIUMTEXT or MEDIUMBLOB?
Q3: Where (how) stored TEXT and BLOB?
Q4: What type of variable stored in row and what out from row?
Q5: What is the row size limit for MyISAM?



Edited 1 time(s). Last edit at 07/21/2009 04:54AM by Zsolt Kendi.

Options: ReplyQuote


Subject Written By Posted
LONGBLOB and LONGTEXT Zsolt Kendi 07/21/2009 04:31AM
Re: LONGBLOB and LONGTEXT Zsolt Kendi 07/21/2009 01:05PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.