What is the difference between char and varchar data types?
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 max_used_connections in mysql?
How to print message in mysql trigger?
How much does mysql enterprise cost?
What is a blob datatype?
How is data stored in mysql?
What are the indexes in mysql?
Why MySQL is used?
Is mysql a scripting language?
What are the different column comparison operators in mysql?
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 ?
How to extract a unit value from a date and time?
Write a command to view mysql database table structure?
What is ISAM?
Why do we use preparedstatement?
How can you take the backup and restore a mysql database using php?