>Another "versus" question.
>
>What are some of the advantages of choosing NChar (or NVarChar) over Char (or VarChar)? Char and VarChar consumes 1 byte per character and NChar and NVarChar consumes 2 bytes per character, correct?

Einar,

The data types with N prefix (nchar, nvarchar and ntext) are used to store the Unicode data but each chracter uses 2 bytes to store.