What is the difference between char and varchar data types?
- 6 Answers
- 46942 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
how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...
How do I copy a table in mysql workbench?
How can we get total number of records by query in mysql?
How do I export mysql query results to excel?
How do I run mysql without installing?
What is difference between mysql mysqli and pdo?
What are the types of index?
How do I change the max connections in mysql?
Does mysql scale well?
What is csv?
What is a session in mysql?
What does mysql workbench do?
Is sql similar to mysql?
Is null in mysql?
What is the size of mysql database?
