What is the difference between CHAR and VARCHAR data types?

Answer Posted / shekoli

Char is a fixed lenth datatype. Ex: char(7), welcome

but varchar is a variable length datatypes, Ex:
varchar(7),welcome (or) come

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we encrypt and decrypt a data presented in a table using mysql?

552


How do I fix a crashed mysql database?

492


What are the steps required to view your mysql database?

614


How do I select a database in mysql?

491


How to update database permissions/privilages.

538






what is constraints? Also explain the different types of constraints?

519


What is the difference between mysql_fetch_assoc and mysql_fetch_array?

449


How do I assign a variable in mysql?

477


What is text?

558


What is datatype in mysql?

474


Explain the difference between primary key and candidate key in mysql?

515


What is difference between microsoft sql and mysql?

489


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

641


What is mysqli_num?

506


What is processlist in mysql?

496