What is the difference between CHAR and VARCHAR data types?
Answer Posted / rajan vardawaj
CHAR is a fixed length data type. CHAR(n) will take n
characters of storage even if you enter less than n
characters to that column. For example, “Hello!”
will be stored as “Hello! ” in CHAR(10) column. VARCHAR is a
variable length data type. VARCHAR(n) will take only the
required storage for the actual number
of [...]
| Is This Answer Correct ? | 27 Yes | 2 No |
Post New Answer View All Answers
What is difference between mysql mysqli and pdo?
How do I run mysql without installing?
How do I transfer data from one database to another in mysql?
How do I save in mysql?
What are the advantages of a procedure?
What is the date format in mysql?
What does mysql_query return?
What is the default port for mysql and how it can change?
How to show table names with 'mysqlshow'?
What is ndb in mysql?
What is database engine in mysql?
What is blob datatype in mysql?
What is the use of i-am-a-dummy flag in mysql?
In mysql, what is the default storage engine?
Is mysql free download?