The NVARCHAR data type stores strings of varying lengths. The string can include digits, symbols, and single-byte and (in some locales) multibyte characters. The main difference between VARCHAR and NVARCHAR data types is the collation order. Collation of VARCHAR data follows code-set order, but NVARCHAR collation can be locale specific, if DB_LOCALE (or SET COLLATION) has specified a localized collation. (The section Collating VARCHAR Values describes an exception.)
A column declared as NVARCHAR, without parentheses or parameters, has a maximum size of one byte, and a reserved size of zero.
No more than 195 columns of the same table can be NVARCHAR data types.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]