+ 1

difference between c h ar and varchar data types

22nd Sep 2016, 10:42 AM
neha - avatar
2 Answers
+ 1
A char(n) entry will always fill n bytes, a varchar(n) entry will have the data + its size (with max size as n). Use char when there is little variation between the size of the entries, and varchar otherwise.
22nd Sep 2016, 11:59 AM
Zen - avatar
in char only use for character and worlds , in varchar use for numeric and also char
14th Oct 2016, 1:15 PM
Ranjeet Chundavadara
Ranjeet Chundavadara - avatar