MySQL Forums :: Performance :: VARCHAR(4096) or TEXT
VARCHAR(4096) or TEXT
Posted by: Justin Keller ()
Date: November 12, 2009 10:20PM
Hello, wondering which is the better column type for messages, such as private messages and posts.
VARCHAR(4096)
or
TEXT
I have read that text columns cannot be indexes, but which takes less disk space? Running MySQL 5.0.86. Thanks.
VARCHAR(4096)
or
TEXT
I have read that text columns cannot be indexes, but which takes less disk space? Running MySQL 5.0.86. Thanks.
| Subject | Views | Written By | Posted |
|---|---|---|---|
| VARCHAR(4096) or TEXT | 172 | Justin Keller | 11/12/2009 10:20PM |
| Re: VARCHAR(4096) or TEXT | 75 | Rick James | 11/17/2009 10:15PM |
Sorry, only registered users may post in this forum.
© 1995-2008 MySQL AB, 2008- Sun Microsystems, Inc.