Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between char and varchar data types?
- 6 Answers
- 48024 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 to dump one database for backup.
How to add a new column to an existing table in mysql?
What are the applications required to support mysql?
How to create table show example
Does mysql scale well?
Why we use mysql workbench?
How do I edit a database in mysql workbench?
What is the limit of mysql database?
What is row?
How do I start mysql?
How do I rename a table in mysql?
Is mysql running ubuntu?
What is mysqli_result?
What does mysql_fetch_assoc do?
What is difference between pdo and mysqli?
