Re: differences between varchar and text fields

2006-04-03 Thread Adam i Agnieszka GÄ…siorowski FNORD
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

differences between varchar and text fields

2006-01-19 Thread Tucker Cunningham
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