I am having issues syncing when my database field type is set to NVARCHAR.

ODBC Link and Wireless Server do not support the use of the NVARCHAR field type. You must either change the field type to a VARCHAR or cast as a VARCHAR if you are using a view.