Get support for using the standard built-in InnoDB storage engine distributed by MySQL from other users and from InnoDB developers themselves.
Re: Comparison between varchar and text in InnoDB
Date: May 07, 2008 15:11
Alan,
From InnoDB's perspective varchar, text and blob are laid out on the disk in exactly same way. If you are interested in the internal details, there is a difference in the way InnoDB passes the varchar and text values back to MySQL. In case of varchar the value is passed back inside the row buffer whereas in case of text the row buffer contains a pointer to a chunk of memory containing actual value. But again this is more like a detail of MySQL storage engine interface and should be irrelevant to the end user.
regards,
inaam