Friday, 25 May 2012

Difference Between Varchar and nVarchar

Difference Between Varchar and nVarchar

VARCHAR is an abbreviation for variable-length character string where as The abbreviation of NVarchar is uNicode Variable Length character String.VARCHAR is a string of text characters that can be as large as the page size for the database table holding the column in question. The size for a table page is 8,196 bytes, and no one row in a table can be more than 8,060 characters. This in turn limits the maximum size of a VARCHAR  to 8,000 bytes.

No comments:

Post a Comment

Note: only a member of this blog may post a comment.