Ask questions which are clear, concise and easy to understand.
Ask QuestionPosted by L Koiren Singha 7 years, 5 months ago
- 0 answers
Posted by Reetesh Gupta 7 years, 5 months ago
- 0 answers
Posted by Reetesh Gupta 7 years, 5 months ago
- 0 answers
Posted by Reetesh Gupta 7 years, 5 months ago
- 1 answers
Posted by Reetesh Gupta 7 years, 5 months ago
- 0 answers
Posted by Reetesh Gupta 7 years, 5 months ago
- 0 answers
Posted by Reetesh Gupta 7 years, 5 months ago
- 0 answers
Posted by Ancious Phawa 7 years, 5 months ago
- 0 answers
Posted by Tanu Shree 7 years, 5 months ago
- 0 answers
Posted by Omi Sharma 4 years, 2 months ago
- 1 answers
Sia ? 4 years, 2 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 Aadhya Maheshwari 7 years, 5 months ago
- 0 answers
Posted by Pratap Chauhan 7 years, 5 months ago
- 1 answers
Aadhya Maheshwari 7 years, 5 months ago
Posted by Harsh Rana 7 years, 5 months ago
- 1 answers
Somiya Sharma 7 years, 5 months ago
Posted by Bhavesh Kukreja 7 years, 5 months ago
- 0 answers
Posted by Somiya Sharma 7 years, 5 months ago
- 1 answers
Avinash Kumar 7 years, 5 months ago
Posted by Preeti Parmar 7 years, 5 months ago
- 0 answers
Posted by Preeti Parmar 7 years, 5 months ago
- 0 answers
Posted by Preeti Parmar 7 years, 5 months ago
- 0 answers
Posted by Preeti Parmar 7 years, 5 months ago
- 0 answers
Posted by Gurchetan Singh 7 years, 5 months ago
- 0 answers
Posted by Gautam Sharma 7 years, 5 months ago
- 0 answers
Posted by Vaibahv Sahu 7 years, 5 months ago
- 0 answers
Posted by Srishti Sharma 7 years, 5 months ago
- 0 answers
Posted by Siddarth Jain 7 years, 5 months ago
- 0 answers
Posted by Akshay Sharma 7 years, 5 months ago
- 1 answers
Adhi Mp 7 years, 5 months ago
Posted by Ashish Singh 7 years, 5 months ago
- 0 answers
Posted by Ak G 7 years, 5 months ago
- 0 answers
Posted by Parthiv Patel 7 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