Ask questions which are clear, concise and easy to understand.
Ask QuestionPosted by Lokesh Choudhary 6 years, 6 months ago
- 2 answers
Posted by Tushar Rangra 6 years, 6 months ago
- 1 answers
Riyaz Ahmed 6 years, 6 months ago
Posted by Tushar Rangra 6 years, 6 months ago
- 1 answers
Posted by Ritesh Narwal 4 years, 3 months ago
- 1 answers
Sia ? 4 years, 3 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 Ananya Rajak 6 years, 6 months ago
- 1 answers
Posted by Karan Chaudhary 6 years, 6 months ago
- 2 answers
Pihu Arora 6 years, 6 months ago
Ananya Rajak 6 years, 6 months ago
Posted by Harsharn Kaur Sandhu 6 years, 6 months ago
- 0 answers
Posted by Keshow Prasad 6 years, 6 months ago
- 1 answers
Harsh Chahar 6 years, 6 months ago
Posted by Steejeet Majumder 6 years, 6 months ago
- 1 answers
Posted by Jyoti Jadhav 6 years, 6 months ago
- 0 answers
Posted by Anjali Patil 6 years, 6 months ago
- 0 answers
Posted by Shubham Sharma 6 years, 6 months ago
- 1 answers
Dgf Chd 6 years, 6 months ago
Posted by Vicky Shrivastav 6 years, 6 months ago
- 0 answers
Posted by Amab Shukla 6 years, 6 months ago
- 0 answers
Posted by Ashiyana Parveen 6 years, 6 months ago
- 0 answers
Posted by Mansi R 6 years, 6 months ago
- 0 answers
Posted by Umair Syeed 6 years, 6 months ago
- 0 answers
Posted by Gokul Maru 5 years, 5 months ago
- 2 answers
Posted by Om Parkash Sharma 6 years, 6 months ago
- 0 answers
Posted by Puspal Singha 6 years, 6 months ago
- 2 answers
Harsh Chahar 6 years, 6 months ago
Harsh Chahar 6 years, 6 months ago
Posted by Baljeet Singh Happy 6 years, 6 months ago
- 0 answers
Posted by Hardeep Singh 6 years, 6 months ago
- 0 answers
Posted by Ayush Kumar 6 years, 6 months ago
- 2 answers
Posted by Harsh Chahar 6 years, 6 months ago
- 0 answers
Posted by Kaifiya Choudhary 6 years, 6 months ago
- 1 answers
Harsimran Singh? 6 years, 6 months ago
Posted by Priyanshu Parmar 6 years, 6 months ago
- 1 answers
Posted by Priyanshu Parmar 6 years, 6 months ago
- 0 answers
Posted by Jasdeep Singh 6 years, 6 months 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
Beauty Queen? Miss Sweetu? 6 years, 6 months ago
2Thank You