Question

What is the difference between CHAR and VARCHAR?
Please write atleast 2 points of difference.

Answer 1

Hey mate!

Here's your answer!

• CHAR includes only characters while VARCHAR includes both numbers and characters.

• VARCHAR also does not accepts values that contains only numbers or only characters. But CHAR accepts only characters.

• Eg: VARCHAR - 'HelloWorld123'

CHAR - 'HelloFriend'

Hope it helps :)