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

What is the difference between CHAR and VARCHAR data types?

Question Posted / shekoli

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

Please Help Members By Posting Answers For Below Questions

What is trigger in mysql with example?

968

What is procedural api?

1042

List data types in mysql? Explain

967

How can we run batch mode in mysql?

1125

What is the command used to create a database using php and mysql?

1193

What is pdo in php mysql?

984

Consider you have the following three tables which have to be linked together.

937

What is root password?

963

How do I import database through command line?

1068

What is offset limit?

1000

How to display top 10 rows in mysql?

1086

How to delete a trigger in mysql?

977

Is mysql case-sensitive?

944

What are the advantages of mysql in comparison to oracle?

1064

Can foreign key have duplicate values?

934