What is the difference between CHAR and VARCHAR?[Nuclear power plant-2018]
##CHAR and VARCHAR are differ in storage and retrieval.
##CHAR column length is fixed while VARCHAR length is variable.
##The maximum no. of character CHAR data type can hold is 255 character while VARCHAR can hold up to 4000 character. (IN MySql limit is 65,535 characters)
##CHAR is 50% faster than VARCHAR.
##CHAR uses static memory allocation while VARCHAR uses dynamic memory allocation.
##CHAR column length is fixed while VARCHAR length is variable.
##The maximum no. of character CHAR data type can hold is 255 character while VARCHAR can hold up to 4000 character. (IN MySql limit is 65,535 characters)
##CHAR is 50% faster than VARCHAR.
##CHAR uses static memory allocation while VARCHAR uses dynamic memory allocation.
No comments:
Post a Comment