Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between char and varchar data types?
- 6 Answers
- 47831 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
What is meant by sharding?
How do I know if mysql is installed on windows?
Do I need python for mysql?
How can you plan the logshipping before processing?
How do I connect to mysql database?
How do you backup a database in mysql?
Why do gaps in sequences occur?
How do I assign a variable in mysql?
What is a transaction? Describe mysql transaction properties.
What, if a table has one column defined as TIMESTAMP?
What are the critical issues you have resolved in your company
How to write date and time literals?
What is data in mysql?
Is mysql free for commercial use?
How does mysql store data?
