On Tue, 13 Jan 2004 12:40, Justin French wrote; > Can someone please calrify when I would use VARCHAR 255, and when > I would use TINYTEXT (which also has a length of 255)?
I think the difference between a VARCHAR and a TEXT column is that the TEXT is saved as a reference to its own row-like object, that requires another access to the tablespace to retrieve. Based on this possibly rash assumption, it would seem that it is a good idea to use a TINYTEXT if you have a column which is usually not selected, if you are scanning the entire table (via unindexed columns) a lot. -- Sam Vilain, [EMAIL PROTECTED] "Automatic" simply means that you cannot repair it yourself. - anon. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]