char stores only character values whereas varchar can stores alphanumeric

What is the difference between char and varchar data types?

Question Posted / deven verma

Answer Posted / deven verma

char stores only character values whereas varchar can
stores alphanumerics values. searching is faster in char in
comparision of varchar

Is This Answer Correct ?

53 Yes

80 No

Please Help Members By Posting Answers For Below Questions

What is ISAM?

1121

What is delimiter in mysql trigger?

962

How many columns can a mysql table have?

911

How to set mysql variable in php?

931

What is the default password for mysql?

904

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

974

What is database engine in mysql?

943

What is not null in mysql?

1004

How do stored procedures work?

1056

Can you tell what are various ways to create an index?

884

How can you take the backup and restore a mysql database using php?

962

How important is to list the column names when doing an insert?

1051

What is delimiter in mysql stored procedure?

921

What are the 3 main types of search queries?

839

Does adding an index lock a table?

963