Re: differences between varchar and text fields
On 2006-01-20, at 01:13, Tucker Cunningham wrote:
So, my question is: what are the pros and cons of using varchar
vs. text/longtext? Right now, longtext seems to be the best option
(it provides most flexibility in data that can be stored, at only a
2-byte-per-row storage premium) There must be some drawback, what
am I missing? Thanks for your help
Using VARCHAR instead of LONGTEXT for no reason you misinform the
optimizer giving it less data to reason out how to go about to perform
faster calculations and give you results You (or your program) - that
is data - expect. Think of it as reverse EXPLAIN.
--
Seks, seksić, seksolatki... uri: news:pl.soc.seks.moderowana ,
http://www.okcupid.com/tests/take?testid=7062295162911411482 ,
If you could only see what love has made of me, I'd... { (.A.)' }
no longer be in *your* mind the mind the difficult kind...{ A.A }
smime.p7s
Description: S/MIME cryptographic signature
differences between varchar and text fields
hi all - I was looking for some clarification about the difference between varchar and the text types in MySQL 5.0.18. It seems to me that varchar and text both hold text data, are variable length, and have the same storage requirements (4 + L bytes). Also, longtext adds the ability to hold ~4G of data at the cost of only 2 extra storage bytes? Also, it looks like text data is stored externally from the table, where varchar is stored within its row. So, my question is: what are the pros and cons of using varchar vs. text/longtext? Right now, longtext seems to be the best option (it provides most flexibility in data that can be stored, at only a 2-byte-per-row storage premium) There must be some drawback, what am I missing? Thanks for your help -tucker -- Tucker Cunningham Integration Appliance Inc. email: [EMAIL PROTECTED] cell: 650.387.5980 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
