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 do I assign a variable in mysql?

978

How do I install the latest mysql on ubuntu?

969

What is auto increment in mysql?

949

Why do we use mysql?

917

What is mysql aggregate functions? Explain

1061

What is blob and text in mysql?

1159

What is mysql and how it works?

956

What is the difference between mysql and oracle?

951

What are numeric data types?

968

Where’s database data actually stored? Is there a way to see the files which are stored?

961

How do I insert an image into mysql workbench?

939

What is default password for mysql?

850

How many sql ddl commands are supported by 'mysql'?

1117

What is data node in mysql cluster?

972

What is a join in mysql?

891