When you insert string data into an NVARCHAR or NCHAR data type in Microsoft SQL Server, your data might be transformed into Asian characters in the database. This issue occurs when you use SAS/ACCESS Interface to ODBC with a Microsoft ODBC driver and the SAS encoding is UTF-8. The issue is caused by how the Microsoft ODBC driver handles the encoding with UTF-8 SAS and a WLATIN-1 encoded SQL Server database.

Here are the workarounds:

• Set the EASYSOFT_UNICODE=YES environment variable in sasenv_local.
• Use SAS/ACCESS^® Interface to Microsoft SQL Server.
• Use the EasySoft ODBC driver and set this option in the ODBC DSN: Client_Cset=UTF8.
• Use English encoded SAS.

Operating System and Release Information