Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between char and varchar data types?
- 6 Answers
- 47771 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
Explain about the architecture of MYSQL?
What are the types of index?
What are the advantages of mysql?
What is user in mysql?
How can you see all indexes defined for a table?
can you tell how can you display the maximum salary in sql? : Mysql dba
How many TRIGGERS are allowed in MySql table?
Explain the different types of mysql joins.
How to make a column bigger and delete unique from table.
What is query log in mysql?
How do I find mysql database?
How do I start mysql in mysql workbench?
In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?
What is insert query in mysql?
Can we save images in mysql database?
