>>You definitely need to use nvarchar() and not nchar for 100 characters data. If you don't need to store unicode data, use varchar.
>
>Again, my question was about the impact and not the type of field for its storage.
You will save disk space. Performance can also be better.
If it's not broken, fix it until it is.
My Blog