We are doing a software upgrade and data migration from an Access 2000 app using SQL server 2000 to a .NET fromtend with SQL server 2005 backend. It is about 50% purchased app with 50% custom code added.

Now the question. The app has changed to using nvarchar. So all thier tables use that. Our tables use varchar. Should we keep them that way? Should we change to nvarchar for consistency? As far as I can tell we don't explicitly use unicode chars anywhere so will changing just increase network traffic and the storage on the DB? Is there any benefit at all to using nvarchar?

Thanks.