Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between char and varchar data types?
- 6 Answers
- 48045 Views
- I also Faced
- E-Mail Answers
Answer Posted / dinesh goyal
char is used for fixed length memory storage whereas varchar
is used for variable lenght memory storage.
Fox Example if we have char(10) then we can store 10 bit
value in it but if we store only 6 bit value in it then rest
of the 4 bit space is goes wasted. this limitation is
overcome by varchar.
In varchar if we use less space than define space the rest
of space is not wasted.
| Is This Answer Correct ? | 363 Yes | 24 No |
Post New Answer View All Answers
How do I update a variable in mysql?
What is ndb in mysql?
What, if a table has one column defined as TIMESTAMP?
How do I uninstall mysql connector?
How to return query output in html format?
What is difference between mysql and mysqli?
Where is the mysql config file?
What is mysql protocol?
How do I connect to a database in mysql workbench?
What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?
What is a left join mysql?
How do I kill a mysql connection?
List data types in mysql? Explain
Explain the difference between mysql and mysql interfaces in php?
Write a command to list all databases in mysql?
