Image

Imagevalera wrote in Imagewebdev

Listens: Papa Roach - Infest

varchar in databases

What difference does it make what size the varchar field is set to (as long as it's not too small) if it will be shrunk down to the size of the data in it anyway?

e.g. a varchar(20) will shrink down to 6 characters when "valera" is in it, the same as a varchar (50) or varchar(200). so why not always use the largest one?