Char is a fixed lenth datatype. Ex: char(7), welcome but varchar is a va

What is the difference between CHAR and VARCHAR data types?

Question Posted / shekoli

Answer Posted / shekoli

Char is a fixed lenth datatype. Ex: char(7), welcome

but varchar is a variable length datatypes, Ex:
varchar(7),welcome (or) come

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What happens if null values are involved in expressions?

1035

What is datatype in mysql?

954

What are the 'mysql' command line arguments?

1018

Is mysql still relevant?

912

How do I create a new database in mysql?

912

How do I start mysql from command line?

1014

What are ddl statements in mysql?

1063

How do I change global variables in mysql?

907

Can we rename database in mysql?

952

How to check server status with 'mysqladmin'?

1168

How do we delete a row in a table?

1000

What data structure does mysql use?

1023

What is the default port number of mysql?

952

How do you create a schema?

957

How to validate email addresses in mysql?

1126