What is the difference between char and varchar data types?
Answer Posted / preeti singh
The char is a fixed-length character data type, the varchar
is a variable-length character data type.
Because char is a fixed-length data type, the storage size
of the char value is equal to the maximum size for this
column. Because varchar is a variable-length data type, the
storage size of the varchar value is the actual length of
the data entered, not the maximum size for this column.
You can use char when the data entries in a column are
expected to be the same size.
You can use varchar when the data entries in a column are
expected to vary considerably in size.
Is This Answer Correct ? | 90 Yes | 7 No |
Post New Answer View All Answers
How to get a version of mysql?
What is the difference between MyISAM Static and MyISAM Dynamic?
Is there a free mysql?
Can we write pl sql mysql?
explain GROUPBY & HAVING clause with examples.
How internally data stores in MyISAM and INNODB table types?
How do I install mysql on windows 10 64 bit?
What is the difference between the primary and unique key in mysql?
How can we get total number of records by query in mysql?
How do I make an action query?
I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?
How can we run batch mode in mysql?
What are the column comparisons operators?
Write a command to view mysql database table structure?
What is a left join mysql?