A Char field into a table will reserve and always use the number of characters you give it (filling the field with blanks). It is like a "dim s as string * 20" in VB.

A VarChar field is variable length and will contains a maximum of character specified into the declaration and is not filled with blanks so it can actually take less space into the table. It is like a "dim s as string" in VB.

the N in front of any character datatype is to tell that the field will be saved into unicode format.


>I am very new with this .. what I want to ask is: what's the difference between char and nvarchar? .. please explain .. many thanks
>
>
>Winan