What is the difference between char and varchar data types?
Answer Posted / preeti singh
The char is a fixed-length character data type, the varchar
is a variable-length character data type.
Because char is a fixed-length data type, the storage size
of the char value is equal to the maximum size for this
column. Because varchar is a variable-length data type, the
storage size of the varchar value is the actual length of
the data entered, not the maximum size for this column.
You can use char when the data entries in a column are
expected to be the same size.
You can use varchar when the data entries in a column are
expected to vary considerably in size.
| Is This Answer Correct ? | 90 Yes | 7 No |
Post New Answer View All Answers
What is the innodb in mysql?
What is the datatype of image?
What tools available for managing mysql server?
table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases
Tell us something about heap tables?
How do I find mysql location?
How will you export tables as an xml file in mysql?
What is row?
What data type is money?
Can we use mysql and mysqli together?
What is difference between unix timestamp and mysql timestamp?
How to run a sql statement?
What is a join? Explain the different types of mysql joins.
Is mysql running ubuntu?
What are triggers mysql?