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

Can you tell few best practices to be followed for optimization in sql?

971

What is a user defined variable?

949

If we use sum function in mysql, does it return sum of that row or for that column?

1021

What is 1nf 2nf 3nf?

1030

What does mysql flush tables do?

1008

Can mysql handle billions of records?

1136

How database are managed?

1043

What is use command in mysql?

1088

How does php communicate with mysql?

949

Write a query to count the number of rows of a table in mysql.

982

What are the types of queries?

981

Can varchar be primary key?

970

How do I start mysql in mysql workbench?

1001

What is difference between mysqli and pdo?

996

How do I truncate all tables in mysql?

1034