What is the difference between CHAR and VARCHAR data types?

Question Posted / rajan vardawaj

2 Answers
7792 Views
Ramco, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is the difference between CHAR and VARCHAR data types?..

Answer / rajan vardawaj

CHAR is a fixed length data type. CHAR(n) will take n
characters of storage even if you enter less than n
characters to that column. For example, “Hello!”

will be stored as “Hello! ” in CHAR(10) column. VARCHAR is a
variable length data type. VARCHAR(n) will take only the
required storage for the actual number

of [...]

Is This Answer Correct ?

27 Yes

2 No

What is the difference between CHAR and VARCHAR data types?..

Answer / 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

Post New Answer