Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between char and varchar data types?
- 6 Answers
- 48253 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 you create a primary key?
How to convert dates to character strings?
How we can see all indexes defined for a table in mysql?
table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases
What is query design?
What are the different column comparison operators in mysql?
What is different between sql and mysql?
What are the different mysql database engines?
What is action query?
What is mysql procedure?
Is mysql a programming language?
Is mysql a dbms?
Tell us something about heap tables?
How to represent ENUMs and SETs internally?
How do I show users in mysql?
