Is there any good reason to use VARCHAR over TEXT for a string field? ie.
performance hits, etc.
Other than running into the row size limit problem, are there any large
storage / performance penalties of using TEXT for virtually all strings?
For ex. A phone number. This field probably wouldn't be bigger that 40
characters, but I can use TEXT and be sure that nothing gets truncated. Same
with a "name" field.
-rchit
