Header Ads

What is difference between char and varchar?


DATABASE MANAGEMENT SYSTEM



What is difference between char and varchar?

Ans-The difference between char and varchar is that of fixed length and variable length.The CHAR datatypes specifies a fixed length character string.When a column is given datatype as CHAR(n) then MySQL ensures that all values stored in that column have this length.But on other hand when a column is given datatype as VARCHAR(n) ,then the maximum size of a value in this column stores exactly what we specify.

Post a Comment

0 Comments