Loading

What is the difference between the data types char and varchar?

Yasvant M

17y5.8kSQL

a).Nothing, they are essentially the same. b).Char uses all of the space allocated, whereas varchar uses only as much space as the characters actually stored. c).Char stores only numeric values, whereas varchar can store any text.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Lalit M17y ago
Accepted answer
My answer is b).Char uses all of the space allocated, whereas varchar uses only as much space as the characters actually stored.
0
Satyanarayan Bajoria17y ago
Hi,

The main difference between char and varchar is that char takes the completely memory specify while declaring where as varchar takes the memory only the value assign to it and rest of the memory will be released.

So when we know the size go for char and when we don't know the size go for varchar.
0