One of our clients has data on their internal SQL Server which they will be sending to our webserver periodically using the MySQL ODBC driver. In the testing we've done so far we've had problems ...

Is NVARCHAR in SQL Server the same or similar to VARCHAR2 in Oracle? I might be wrong but doesn't SQL Server also support VARCHAR2? If so, what benefits (or problems) come from using NVARCHAR?