Guys,
I started thinking (I hate when that happends late on a Friday afternoon): Are there any performance issues between choosing field type NChar and NVarChar?

Take a simple example like an email field. With field type NChar I would normaly reserve 40 (or maybe even 50) characters. Most email addresses are way shorter than 40 (or 50) characters so disk cost would improve if I decided to use NVarChar instead of NChar.

Now you might ask why am I worried about disk cost and the answer to that is that I am not worried about disk cost but the guy that will duplicate my tables on the Pocket PC (SQL CE) is worried about disk cost and he is counting bytes (and bits).

So is there a performance hit by choosing NVarChar over NChar? (If it is then my decision is simple <s>)

Any other random thoughts will also be appreciated.

Einar