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
explain GROUPBY & HAVING clause with examples.
How to create a new table in mysql?
What is unique key in mysql?
Which statement is used to delete a table in MySQL.
Can we store pdf files in mysql?
What is different between sql and mysql?
what is constraints?
What does the file with the extension: frm, myd, and myi contain?
What is mysqladmin flush hosts?
What are the types of queries?
Is mysql a framework?
Is mysql running ubuntu?
How to return query output in html format?
How to get a version of mysql?
Is mysql a scripting language?