0

I have a very general question regarding length of the data type. suppose i have assigned a varchar(2500) and i am using only up-to 100 bytes. will the rest of the unused length specified by me affect any thing?

Harpreet
  • 709
  • 5
  • 14
Ethen
  • 161
  • 3
  • 3
  • 16
  • The answer from http://dba.stackexchange.com/a/1782 might be helpful. – viclim Apr 12 '13 at 06:44
  • you will find [this](http://stackoverflow.com/a/1243018/892788) and [this](http://stackoverflow.com/questions/5353159/does-the-database-maximum-field-length-affect-performance) useful. – diyoda_ Apr 12 '13 at 06:45

2 Answers2

0

VARCHAR will take only 100. Rest of memory will be used by another fields.

Harpreet
  • 709
  • 5
  • 14
0

Check out this reference(mysql) : http://dev.mysql.com/doc/refman/5.0/en/char.html

user112233
  • 41
  • 5