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 use mysql procedures?
What is timestamp in mysql?
How to create a table?
How to get data from mysql in php?
What are the non-standard sql commands supported by 'mysql'?
In which year mysql created?
What are the steps required to view your mysql database?
Why phpmyadmin is used for mysql?
How do I find the database name in mysql?
Can we create table in stored procedure?
Can not connect to mysql server 10060?
What is the role of a limit in a mysql query?
What is mvcc in mysql?
How do I restore a mysql database?
How to check if value already exists in mysql database in php?