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)...
hookup ur code with us