Resolved: CHAR vs VARCHAR
In the lecture "String Data Types". The part in which the instructor is explaining the differences between CHAR and VARCHAR is not clear due to an audio glitch. Please tell me the differences between CHAR and VARCHAR?
Regards,
Archisman ( Archie)
1 answers ( 0 marked as helpful)
Hi Archisman!
Thanks for reaching out.
You’re probably wondering why CHAR exists considering the fact that VARCHAR is a lot more responsive to the data value inserted. Also, VARCHAR would require smaller storage if the value inserted is shorter than the defined maximum size.
The reason is strictly technical and it concerns mainly advanced users. When processing data, CHAR is about 50% faster than VARCHAR. In our course, this contrast in speed will be of no significance, but when professionals must deal with huge amounts of data, such a difference can become important.
Hope this helps.
Best,
Martin
Best,
Martin