<\/p>\n\n\n\n\n\n\n\n\n\n\n

\n Char<\/strong><\/h3>\n<\/td>\n	\n VarChar<\/strong><\/h3>\n<\/td>\n<\/tr>\n
Char data type is used for storing single character values<\/td>\n	It is a SQL Code that helps in storing variable character<\/td>\n<\/tr>\n
Used to store characters string of fixed length specified<\/td>\n	If a length of a string is less than the set or fixed length then it will store as it is without including any extra blank spaces.<\/p>\n  <\/td>\n<\/tr>\n
Size is fixed. Cannot be changed during runtime<\/td>\n	Storage size of VARCHAR datatype is equal to the actual length of the entered string in bytes.<\/p>\n  <\/td>\n<\/tr>\n
Can Store only characters<\/td>\n	We should use this datatype when we expect the data values in a column are of variable length.<\/p>\n  <\/td>\n<\/tr>\n
Memory is allocation is Static<\/strong><\/td>\n	Memory is allocated Dynamically<\/strong><\/td>\n<\/tr>\n
Per Character contains 1 byte<\/td>\n	For Storing it uses 1 byte per character Plus 1 or 2 extra bytes for stroing varying length.<\/td>\n<\/tr>\n
Since the size of the char is fixed and cannot be changed, there will be a memory wastage.<\/p>\n  <\/td>\n	To store a character string value of set length then varchar data type is used<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":" Char VarChar Char data type is used for storing single character values It is a SQL Code that helps in storing variable character Used to store characters string of fixed length specified If a length of a string is less than the set or fixed length then it will store as it is without including […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"passster_activate_protection":false,"passster_protect_child_pages":"","passster_protection_type":"password","passster_password":"","passster_activate_overwrite_defaults":"","passster_headline":"","passster_instruction":"","passster_placeholder":"","passster_button":"","passster_id":"","passster_activate_misc_settings":"","passster_redirect_url":"","passster_hide":"no","passster_area_shortcode":"","gtb_hide_title":false,"gtb_wrap_title":false,"gtb_class_title":"","gtb_remove_headerfooter":false,"footnotes":""},"categories":[6547],"tags":[18630,18628,18626,18638,18631,18641,18640,18635,18634,18633,18629,18627,18637,18639,18642,18636,18632],"class_list":["post-4864","post","type-post","status-publish","format-standard","hentry","category-sql","tag-and-varchar2-difference-between-char-and-varchar-and-varchar2","tag-char-vs-varchar-in-sql","tag-difference-between-char","tag-difference-between-char-and-varchar-class-10","tag-difference-between-char-and-varchar2-in-sql","tag-difference-between-varchar-and-varchar2-and-nvarchar","tag-difference-between-varchar-and-varchar2-in-mysql","tag-difference-between-varchar-and-varchar2-sql","tag-how-are-varchar-and-varchar2-different","tag-shoud-i-use-char-or-varchar2","tag-varchar","tag-varchar-and-varchar2-in-sql","tag-varchar-varchar2-and-nvarchar-in-sql","tag-varchar2-data-type","tag-varchar2-in-sql","tag-varchar210-means","tag-what-is-the-major-difference-between-varchar2-and-char"],"yoast_head":"\n