1.

What Is The Difference Between Char And Varchar?

Answer»

A LIST of differences between CHAR and VARCHAR:

  • CHAR and VARCHAR types are different in storage and RETRIEVAL.
  • CHAR column length is fixed to the length that is declared while CREATING table. The length value ranges from 1 and 255.
  • When CHAR values are STORED then they are right padded using SPACES to specific length. Trailing spaces are removed when CHAR values are retrieved.

A list of differences between CHAR and VARCHAR:


Discussion

No Comment Found

Related InterviewSolutions