What is fixed-length & variable-length characters? Tell me their differences??

 Posted by Nishithraj on 1/29/2010 | Category: Sql Server Interview questions | Views: 2453

In Sql Server there are two types of character data types. They are

1.fixed-length (i.e char)
2.variable-length (i.e varchar)

The main differences are maximum length and in whether trailing spaces are retained

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response