Ask questions which are clear, concise and easy to understand.
Ask QuestionPosted by Varshita Virwal 6 years, 11 months ago
- 0 answers
Posted by Tanisha Sharma 6 years, 11 months ago
- 0 answers
Posted by Navnish Singh 6 years, 11 months ago
- 0 answers
Posted by Pranshu Adlakha 6 years, 11 months ago
- 0 answers
Posted by Bhavesh - 6 years, 11 months ago
- 0 answers
Posted by Anuj Mishra 6 years, 11 months ago
- 0 answers
Posted by Madhav Bairathi 6 years, 11 months ago
- 0 answers
Posted by Madhav Bairathi 6 years, 11 months ago
- 0 answers
Posted by Rishikesh Saike 6 years, 11 months ago
- 0 answers
Posted by Santosh Tripathi 6 years, 11 months ago
- 0 answers
Posted by Tanya Chauhan 6 years, 11 months ago
- 0 answers
Posted by Dia Rajput 6 years, 11 months ago
- 0 answers
Posted by Hemang Agrawal 6 years, 11 months ago
- 0 answers
Posted by Nitesh Singh 6 years, 11 months ago
- 0 answers
Posted by Sakshi Chourasia 3 years, 6 months ago
- 1 answers
Sia ? 3 years, 6 months ago
| SR.NO. | CHAR | VARCHAR |
| 1. | CHAR datatype is used to store character string of fixed length | VARCHAR datatype is used to store character string of variable length |
| 2. | In CHAR, If the length of string is less than set or fixed length then it is padded with extra memory space. | In VARCHAR, If the length of string is less than set or fixed length then it will store as it is without padded with extra memory spaces. |
| 3. | CHAR stands for “Character” | VARCHAR stands for “Variable Character” |
| 4. | Storage size of CHAR datatypes is equal to n bytes i.e. set length | Storage size of VARCHAR datatype is equal to the actual length of the entered string in bytes. |
| 5. | We should use CHAR datatype when we expect the data values in a column are of same length. | We should use VARCHAR datatype when we expect the data values in a column are of variable length. |
| 6. | CHAR take 1 byte for each character | VARCHAR take 1 byte for each character and some extra bytes for holding length information |
| 9. | Better performance than VARCHAR | Performance is not good as compared to CHAR |
Posted by Sourabh Joshi 6 years, 11 months ago
- 0 answers
Posted by Sarah Reynold 6 years, 11 months ago
- 5 answers
Achutti S A 6 years, 11 months ago
Posted by Ranjan Kumar 6 years, 11 months ago
- 1 answers
Reet Gautam 6 years, 11 months ago
Posted by Ranbir Trikha 7 years ago
- 1 answers
Posted by Sumit Tewatia 7 years ago
- 1 answers
Posted by Meraz Khilji 7 years ago
- 0 answers
Posted by Adarsh Upadhyay 7 years ago
- 0 answers
Posted by Garvit Singh Bangari 7 years ago
- 0 answers
Posted by Aparna Aditi 7 years ago
- 0 answers
Posted by Akki Awasthi 7 years ago
- 0 answers
Posted by Vedanshi Singh 7 years ago
- 0 answers
Posted by Dibendu Gorai 7 years ago
- 0 answers
myCBSEguide
Trusted by 1 Crore+ Students
Test Generator
Create papers online. It's FREE.
CUET Mock Tests
75,000+ questions to practice only on myCBSEguide app
