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

Does mysql case matter?

858

What is the difference between the LIKE and REGEXP operators?

976

What are numeric data types?

936

Is mysql query case sensitive?

901

What is mysql data directory?

922

How to start mysql server?

992

What are the different types of triggers in mysql?

912

Can not connect to mysql server 10060?

860

How can we change the data type of a column of a table?

937

What is mysql vs sql?

923

Is mysql relational?

857

How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.

1024

What is the difference between char and varchar?

1091

What is heap table in mysql?

910

How do I restart mysql on windows?

897