Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between char and varchar data types?
- 6 Answers
- 48058 Views
- I also Faced
- E-Mail Answers
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 schema in mysql?
How to execute mysql query in php?
How do I copy a table in mysql?
How do I restore a mysql database dump file in linux?
What is the function of mysqldump?
Which is faster innodb or myisam?
What does mysql flush tables do?
How does triggers work in mysql?
Is mysql relational?
What do we use to remove duplicate records while fetching a data in mysql ?
Explain csv tables.
What are the benefits of mysql?
What causes mysql too many connections?
Why are function needed?
how to take mysql database backup?
