What is the difference between char and varchar data types?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / paras nath
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 ? | 53 Yes | 7 No |
Answer / sonu kumar
i m totally aggred with answer no 1 so my answer will be also like that
Is This Answer Correct ? | 1 Yes | 2 No |
Answer / deven verma
char stores only character values whereas varchar can
stores alphanumerics values. searching is faster in char in
comparision of varchar
Is This Answer Correct ? | 53 Yes | 80 No |
Explain the difference between primary key and candidate key in mysql?
ru compare the 2 null values?
How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.
Can mysql store files?
What is deterministic in mysql?
A select query over a large table runs very slow because of the growing number of entries in that table. What different measures could be taken to improve speed?
What is general log in mysql?
What is the password of mysql?
What is mysql in linux?
Can we use mysql and mysqli together?
What are the advantages and disadvantages of using mysql?
How do I disable mysql?