InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Difference between Char and Varchar Datatyoe |
|
Answer» VARCHAR\xa0is\xa0variable\xa0length, while\xa0CHAR\xa0is fixed length.\xa0CHAR\xa0is a fixed length string\xa0data type, so any remaining space\xa0in the\xa0field is padded with blanks.\xa0CHAR\xa0takes up 1 byte per character. ...\xa0VARCHAR\xa0is a\xa0variable\xa0length string\xa0data type, so it holds only the characters you assign to it. Char fix the space whatever you have given and no more data will be filled in the empty space. But varchar fills the empty space internally ( but show the datatype as what you made) |
|