Problem Note 65939: "ERROR: Unable to transcode data to/from UCS-2 encoding" occurs when you run an SQL query using SAS/ACCESS® Interface to ODBC on SAS® 9.4M5 with UTF-8
 |  |  |  |  |
When you run an SQL query using SAS/ACCESS Interface to ODBC under the following conditions, you might receive an error:
- You run SAS® 9.4M5 (TS1M5) or SAS® 9.4M6 (TS1M6) in a UTF-8 encoding session.
- You try to read character data that is longer than 32,767 bytes.
In this scenario, you see an error similar to the following:
ERROR: Unable to transcode data to/from UCS-2 encoding.
This is a known SAS/ACCESS Interface to ODBC engine bug in SAS 9.4M5 and SAS 9.4M6.
Click the Hot Fix tab in this note to access the hot fix for this issue for SAS 9.4M6.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to ODBC | Windows 7 Professional x64 | 9.4 TS1M5 | 9.4 TS1M7 |
| Windows 7 Professional 32 bit | 9.4 TS1M5 | 9.4 TS1M7 | ||
| Windows 7 Ultimate 32 bit | 9.4 TS1M5 | 9.4 TS1M7 | ||
| 64-bit Enabled AIX | 9.4 TS1M5 | 9.4 TS1M7 | ||
| 64-bit Enabled Solaris | 9.4 TS1M5 | 9.4 TS1M7 | ||
| HP-UX IPF | 9.4 TS1M5 | 9.4 TS1M7 | ||
| Linux for x64 | 9.4 TS1M5 | 9.4 TS1M7 | ||
| Windows 7 Home Premium x64 | 9.4 TS1M5 | 9.4 TS1M7 | ||
| Windows 7 Home Premium 32 bit | 9.4 TS1M5 | 9.4 TS1M7 | ||
| Windows 7 Enterprise x64 | 9.4 TS1M5 | 9.4 TS1M7 | ||
| Windows 7 Enterprise 32 bit | 9.4 TS1M5 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2016 | 9.4 TS1M5 | 9.4 TS1M7 | ||
| Solaris for x64 | 9.4 TS1M5 | 9.4 TS1M7 | ||
| Windows 7 Ultimate x64 | 9.4 TS1M5 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2012 Std | 9.4 TS1M5 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2012 R2 Std | 9.4 TS1M5 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 TS1M5 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2012 Datacenter | 9.4 TS1M5 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2008 for x64 | 9.4 TS1M5 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2008 R2 | 9.4 TS1M5 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2008 | 9.4 TS1M5 | 9.4 TS1M7 | ||
| Microsoft Windows 10 | 9.4 TS1M5 | 9.4 TS1M7 | ||
| Microsoft Windows 8.1 Pro x64 | 9.4 TS1M5 | 9.4 TS1M7 | ||
| Microsoft Windows 8.1 Pro 32-bit | 9.4 TS1M5 | 9.4 TS1M7 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.4 TS1M5 | 9.4 TS1M7 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 TS1M5 | 9.4 TS1M7 | ||
| Microsoft Windows 8 Pro x64 | 9.4 TS1M5 | 9.4 TS1M7 | ||
| Microsoft Windows 8 Pro 32-bit | 9.4 TS1M5 | 9.4 TS1M7 | ||
| Microsoft Windows 8 Enterprise x64 | 9.4 TS1M5 | 9.4 TS1M7 | ||
| Microsoft Windows 8 Enterprise 32-bit | 9.4 TS1M5 | 9.4 TS1M7 | ||
| Microsoft® Windows® for x64 | 9.4 TS1M5 | 9.4 TS1M7 | ||
A fix for this issue for SAS/ACCESS Interface to ODBC 9.4_M6 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/F4C.html#65939A fix for this issue for SAS/ACCESS Interface to Microsoft SQL Server 9.44 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/G4F.html#65939A fix for this issue for SAS/ACCESS Interface to ODBC 9.4_M5 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/B7V.html#65939A fix for this issue for SAS/ACCESS Interface to Microsoft SQL Server 9.43 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/B7X.html#65939| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2020-05-20 13:37:53 |
| Date Created: | 2020-05-06 14:10:57 |