What is the difference between char and varchar data types?
- 6 Answers
- 46175 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 rename a table in mysql?
What are aggregate functions in mysql?
How do I restore a mysql database?
What is difference between statement and preparedstatement?
how you will Create a database on the mysql server with unix shell.
Explain what is mysql?
Can we store images in mysql database?
How to enter boolean values in sql statements?
How can I create a database in mysql?
What is difference between mongodb and mysql?
How do I install the latest mysql on ubuntu?
How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.
Can mysql and mariadb coexist?
How to show all records starting with the letters 'sonia' and the phone number '9876543210'
What is 'mysqlimport'?
