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

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

904

Is mysql query case sensitive?

921

Is mysql server free?

886

When to use order by in delete statement?

988

What is mysql server used for?

915

Is mysql still popular?

880

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

856

What is bdb (berkeleydb)?

897

Which is better mysql or mssql?

882

Is blocked because of many connection errors mysql?

810

What is data directory in mysql?

927

How do you shutdown a mysql database?

1003

What are the technical specifications of mysql?

1107

How to show table structure mysql?

962

Is mariadb faster than mysql?

921