What is the difference between char and varchar data types?
- 6 Answers
- 46947 Views
- I also Faced
- E-Mail Answers
Answer Posted / paras nath
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 ? | 53 Yes | 7 No |
Post New Answer View All Answers
How do I run mysql from command line?
What is 'mysqladmin' in mysql?
How to use count function in mysql?
what is database black box testing? : Mysql dba
What is the default port for MySQL Server?
In which format data is stored in mysql database?
Difference between CHAR and VARCHAR?
Why is mysql used?
Is mysql a backend?
What is ibdata1?
Is blocked because of many connection errors unblock with mysqladmin flush hosts?
Why do we use group by and order by function in mysql?
Where MyISAM table will be stored and also give their formats of storage?
What is use command in mysql?
Which statement is used to delete a table in MySQL.
