Secondary Navigation. 1  Active Duty Dental Care. 2  Guard/Reserve Dental Care. 3  TRICARE Dental Program. 4  TRICARE Retiree Dental Program. 5  Enrolling in the TRICARE Retiree Dental Program. Costs. 6  Dental Benefits for Survivors. 7  Find a Dentist.
â¢ Although char and varchar are character data fields, char is a fixed length data field and varchar is a variable size data field. â¢ Char can store only fixed size non-Unicode string characters, but varchar can store variable sizes of strings.
A SQL Data row has a max limited. size of 8000 bytes. Therefore a VARCHAR(MAX) which can be up to 2 GB in size cannot. be stored in the data row and so SQL Server stores it Out of row. VARCHAR(MAX) is overkill for many types of data such as personâs names, locations, colleges etc.