Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between char and varchar data types?
- 6 Answers
- 48256 Views
- I also Faced
- E-Mail Answers
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
what is the difference between between and in operators in mysql?
What is text in mysql?
How do you create a schema?
What is dump in mysql?
Is sqlite faster than mysql?
What is the difference between primary key and candidate key?
What is delimiter in mysql stored procedure?
How do I delete a mysql user?
What is msql?
Why mysql is open source?
How do I install mysql on windows 7?
How do I change directories in mysql?
What are the limitations of mysql?
What is mysql database server?
What is data directory in mysql?
