Skip to main content

Posts

Showing posts from March, 2011

varchar vs nvarchar

varchar vs nvarchar varchar : - is an abbreviation for variable-length character string .                  This in turn limits the maximum size of a VARCHAR to 8,000 bytes.                  Syntax: - field_name varchar(50); nvarchar : - The "N" in NVARCHAR means uNicode .                    NVARCHAR is nothing more than a VARCHAR that supports two-byte characters.                    The most common use is to store character data that is a mixture of English and non-English symbols(other languages' characters) - such as English and Hindi.                    Syntax: - field_name nvarchar(50);