0

Possible Duplicate:
Importance of varchar length in MySQL table

For example, are VARCHAR(50) and VARCHAR(100) any different other than the max number of chars they can store?

Community
  • 1
  • 1
abc
  • 59
  • 1
  • 4
  • 2
    [Importance of varchar length in MySQL table](http://stackoverflow.com/questions/1962310/importance-of-varchar-length-in-mysql-table/1962329#1962329). – Shef Sep 11 '11 at 18:09

1 Answers1

0

It shouldn't make much difference in most cases. For short but often changing data you could consider using constant sized char instead (that makes a difference when length of contained string changes often).

But when your query makes a temporary table then smaller is better indeed (because they could be converted to constant size char for optimalization reasons, so they will exceed to maximum limit, resulting in larger temporary table).

Ernest Staszuk
  • 214
  • 1
  • 2
  • The answer doesn't make much sense. However, if you see a question has been marked as duplicate there is no need to add an answer, unless you have some substantially different answer from the duplicate one, which would help the OP. Even then you should consider posting it in the original question. – Shef Sep 11 '11 at 18:25