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