MySQL Forums
Forum List  »  General

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

Written By
July 21, 2009 04:31AM
July 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.