What is the difference between char and varchar data types?
Answer Posted / 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 |
Post New Answer View All Answers
What do I do if I forgot my mysql root password?
What is the use of concat() in mysql?
How are mysql timestamps seen to a user?
List the different types of normalization?
What is datatype in mysql?
What is a storage engine?
What you can use regular expression for in mysql?
What are triggers in mysql?
Does mysql use t sql?
How to enter numeric values as hex numbers?
How to dump a table from a database.
What is mysql connection limit?
how can you test for null values in a database? : Mysql dba
Is mysql free for commercial use?
how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?