No products in the cart.

Difference between Char and Varchar Datatyoe

CBSE, JEE, NEET, CUET

Question Bank, Mock Tests, Exam Papers

NCERT Solutions, Sample Papers, Notes, Videos

Install Now

Difference between Char and Varchar Datatyoe

Posted by Ashish Karki 3 years, 8 months ago

CBSE > Class 10 > Information Technology (402)

2 answers

Arnab Das Gupta 3 years, 8 months ago

VARCHAR is variable length, while CHAR is fixed length. CHAR is a fixed length string data type, so any remaining space in the field is padded with blanks. CHAR takes up 1 byte per character. ... VARCHAR is a variable length string data type, so it holds only the characters you assign to it.

1Thank You

Pratibha Maurya 3 years, 8 months ago

Char fix the space whatever you have given and no more data will be filled in the empty space. But varchar fills the empty space internally ( but show the datatype as what you made)

1Thank You

ANSWER

Related Questions

Define goal seek

Posted by Sudharshini Kanthasamy 2 months ago

CBSE > Class 10 > Information Technology (402)

1 answers

Communication should maintain ______in it's objectives

Posted by Manyata Mishra 2 months, 2 weeks ago

CBSE > Class 10 > Information Technology (402)

0 answers

What is the location in the base interface of the link to create a table using wizard

Posted by Chandan Kedia 2 months, 2 weeks ago

CBSE > Class 10 > Information Technology (402)

0 answers

This content has been hidden. One or more users have flagged this content as inappropriate. Once content is flagged, it is hidden from users and is reviewed by myCBSEguide team against our Community Guidelines. If content is found in violation, the user posting this content will be banned for 30 days from using Homework help section. Suspended users will receive error while adding question or answer. Question comments have also been disabled. Read community guidelines at https://mycbseguide.com/community-guidelines.html

Few rules to keep homework help section safe, clean and informative.

Don't post personal information, mobile numbers and other details.
Don't use this platform for chatting, social networking and making friends. This platform is meant only for asking subject specific and study related questions.
Be nice and polite and avoid rude and abusive language. Avoid inappropriate language and attention, vulgar terms and anything sexually suggestive. Avoid harassment and bullying.
Ask specific question which are clear and concise.

Remember the goal of this website is to share knowledge and learn from each other. Ask questions and help others by answering questions.

Posted by Ritik Sirohi 2 months, 2 weeks ago

CBSE > Class 10 > Information Technology (402)

0 answers

Don't post personal information, mobile numbers and other details.
Don't use this platform for chatting, social networking and making friends. This platform is meant only for asking subject specific and study related questions.
Be nice and polite and avoid rude and abusive language. Avoid inappropriate language and attention, vulgar terms and anything sexually suggestive. Avoid harassment and bullying.
Ask specific question which are clear and concise.

Remember the goal of this website is to share knowledge and learn from each other. Ask questions and help others by answering questions.

Posted by Hardika . 2 months, 2 weeks ago

CBSE > Class 10 > Information Technology (402)