When I tried to used Data Service Designer to view data from MSSQL 2008 tables, all the column with data type nvarchar were display as "LONG" . The data were OK when select from database server.
I have configure my datastore as code page UTF8 to support unicode and I have no problem to transfer date to the table with data type nvarchar.
Anyone can help ? thank you.