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
Can we store pdf files in mysql?
How many columns can a table have?
What do you need to connect php to mysql?
What is deterministic in mysql?
What is max_used_connections in mysql?
What are the differences between char and nchar?
What is delimiter in mysql trigger?
How to display odd rows in student table in mysql?
what is the difference between gui testing and database testing? : Mysql dba
How do I create a stored procedure in mysql?
What is session variable in mysql?
How to display top 10 rows in mysql?
What is data type for image in mysql?
Explain about reporting services of MYSQL?
Is mysql a odbc?