Ask questions which are clear, concise and easy to understand.
Ask QuestionPosted by Navnish Singh 7 years, 7 months ago
- 0 answers
Posted by Pranshu Adlakha 7 years, 7 months ago
- 0 answers
Posted by Bhavesh - 7 years, 7 months ago
- 0 answers
Posted by Anuj Mishra 7 years, 7 months ago
- 0 answers
Posted by Madhav Bairathi 7 years, 7 months ago
- 0 answers
Posted by Madhav Bairathi 7 years, 7 months ago
- 0 answers
Posted by Rishikesh Saike 7 years, 7 months ago
- 0 answers
Posted by Santosh Tripathi 7 years, 7 months ago
- 0 answers
Posted by Tanya Chauhan 7 years, 7 months ago
- 0 answers
Posted by Dia Rajput 7 years, 7 months ago
- 0 answers
Posted by Hemang Agrawal 7 years, 7 months ago
- 0 answers
Posted by Nitesh Singh 7 years, 7 months ago
- 0 answers
Posted by Sakshi Chourasia 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 Sourabh Joshi 7 years, 7 months ago
- 0 answers
Posted by Sarah Reynold 7 years, 7 months ago
- 5 answers
Achutti S A 7 years, 7 months ago
Posted by Ranjan Kumar 7 years, 7 months ago
- 1 answers
Reet Gautam 7 years, 7 months ago
Posted by Ranbir Trikha 7 years, 7 months ago
- 1 answers
Posted by Sumit Tewatia 7 years, 7 months ago
- 1 answers
Posted by Meraz Khilji 7 years, 7 months ago
- 0 answers
Posted by Adarsh Upadhyay 7 years, 7 months ago
- 0 answers
Posted by Garvit Singh Bangari 7 years, 7 months ago
- 0 answers
Posted by Aparna Aditi 7 years, 7 months ago
- 0 answers
Posted by Akki Awasthi 7 years, 7 months ago
- 0 answers
Posted by Vedanshi Singh 7 years, 7 months ago
- 0 answers
Posted by Dibendu Gorai 7 years, 8 months ago
- 0 answers
Posted by Somay Khandelwal 4 years, 1 month ago
- 1 answers
Sia ? 4 years, 1 month ago
| Basis | Internal Memory | External Memory |
| Nature | Ram is volatile, but ROM is non-volatile in nature | Non-volatile in nature |
| Other Name | It is also known as Primary or main memory | It is also known as secondary memory |
| Physical Appearance | Looks like chips and is attached to the motherboard inside the computer | Look like a storage device or disk that are portable and connects to every computer |
| Connectivity | Connects internally by inserting chips or when the machine is manufacture | Connect through data cable or externally to the network |
| Data Storage | The Data is stored temporarily to access files faster | The Data is stored permanently for long-term |
| Working Memory | It is a working memory | It is not a working memory |
| Large Data | It cannot store extensive data | It saves a broad amount of data |
| Portability | Non-portable | Portable |
| Example | Ram & Rom | Hard Disk & Optical Drive |
Posted by Krishna Verma 7 years, 8 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
