DataDeploy UTF-8 to UCS-2 in SQL Server 2008

chucktuesday

I have a working DataDeploy 7.0 script that is sending single-byte text (VARCHAR) to SQL Server 2008 just fine now. However, we need to support Unicode for Asian text data. The DCRs have been modified and are storing the data in the XML file correctly. I then changed the database columns to NVARCHAR. However, it's not converting the text before sending it. The documentation only gives VARCHAR as a valid column type and I can't find any mention of UCS-2 or UTF-16. Research on SQL 2008 says that it does not support UTF-8 and conversion needs to take place before it goes to the database. How do I make this work with DataDeploy?

Thank you!

Chuck