Joined: 20 Jul 2008 Posts: 19 Location: Schenactady, US
We know that VARCHAR is a variable char and CHAR is a fixed char. If I declare CHAR(50) then 50 bytes will be allocated and used.
If I declare VARCHAR(50) and I'm giving the length as 10. Then only 10 bytes will be allocated and used.