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

How can I insert images into a Mysql database?

998

What are ddl statements in mysql?

959

What is prepared statement in mysql?

901

What is mysql installer?

947

What is mysql optimization?

857

What is mysql slow query?

898

How many rows can mysql handle?

883

how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.

857

How do I start and stop mysql on windows?

937

using primary can we relate two table, with out foreign key?

2658

What is data types in mysql?

862

What is mysql aggregate functions? Explain

1013

How to create and drop view in mysql?

856

What is mysql connector used for?

880

What is sql vs mysql?

961