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
Why should I learn mysql?
What is difference between oracle sql and mysql?
Explain Access Control Lists.
Why do we use views instead of tables?
What is int mysql?
How do I start mysql manually?
Can I install mysql on mac?
How to add a new column to an existing table in mysql?
How do I know if mysql is installed on windows?
Can we store files in mysql?
What is acid in mysql?
Can you tell the difference between ereg_replace() and eregi_replace()?
List data types in mysql? Explain
What is the difference between mysql and oracle?
How do I change the max connection in mysql?