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


Please Help Members By Posting Answers For Below Questions

What language does mysql use?

432


What is the purpose of -> in the mysql terminal?

641


What do I do if I forgot my mysql root password?

476


What is a select query?

474


How do I edit a trigger in mysql?

486






What is delimiter in mysql trigger?

525


What is the purpose of mysql database?

477


how to take mysql database backup?

577


How do you connect MySQL database with PHP?

530


Can mysql and mariadb coexist?

574


What is memory table?

494


Explain about reporting services of MYSQL?

610


table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases

788


Is there a free mysql?

490


What is mysql sleep process?

516