For example, if I wanted to store a 20 byte character string, would a VARCHAR(50)
field use the same space as a VARCHAR(MAX)
field ?
Varchar(50)
stores a maximum of 50 characters. Varchar(max)
stores a maximum of 2,147,483,647 characters.
But, varchar(50)
keeps the 50 character space even if you don't store 50 characters. but varchar(max)
is flexible to any size. size doesn't matter.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With