0

what is difference between varchar and char?(in terms of memory allocation also)

14th Aug 2016, 6:43 PM
AKSHAY MALVIYA
AKSHAY MALVIYA - avatar
3 odpowiedzi
+ 2
character can allocates static memory and range is 1-2000 characters datatype is char (size). varchar can allocates dynamic memory and range is 1-4000 characters datatype is varchar2(size).
15th Aug 2016, 4:21 PM
k JayaprakashReddy
k JayaprakashReddy - avatar
+ 1
In char, we will give particular no of characters correctly but, in varchar, we will variable no of characters into it for example, if u Give the attribute type as char(20),you will Give 20 characters fully but if you give varchar(20), you give maximum 20 characters into the attribute
19th Aug 2016, 1:44 PM
Rajkumar
- 2
char accept only letters. varchar accept letters and numbers
14th Aug 2016, 8:26 PM
antonio
antonio - avatar