Usage Note 31997: Using SAS/ACCESS® Interface to OLE DB engine and Unicode
 |  |  |  |  |
On SAS 9.1, when a SAS Unicode (SAS/UTF-8) server is connected to Unicode databases using SAS/ACCESS to OLE DB, you might get incorrect data displayed if you are dealing with Unicode national language data on English Windows with the English locale setup. This is because the OLE DB engine is not designed to allow for Unicode processing.
To display Unicode data correctly, you need to change the system locale that is the same as the language you are going to read. Also the SAS session locale has to be the same one.
For example, if your database stores Japanese data with UCS2 encoding, change the Windows Locale to Japanese by going to Control Panel ► Regional and Language Options . Your SAS session locale has to be Japanese too.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP4 | |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M3 SP4 | |||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M3 SP4 | |||
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 SP4 | |||
| Microsoft® Windows® for x64 | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Server | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Professional | 9.1 TS1M3 SP4 | |||
| Microsoft Windows NT Workstation | 9.1 TS1M3 SP4 | |||
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 SP4 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 SP4 | |||
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 SP4 | |||
| Microsoft Windows XP Professional | 9.1 TS1M3 SP4 | |||
| Windows Vista | 9.1 TS1M3 SP4 | |||
| 64-bit Enabled AIX | 9.1 TS1M3 SP4 | |||
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP4 | |||
| 64-bit Enabled Solaris | 9.1 TS1M3 SP4 | |||
| HP-UX IPF | 9.1 TS1M3 SP4 | |||
| Linux | 9.1 TS1M3 SP4 | |||
| Linux on Itanium | 9.1 TS1M3 SP4 | |||
| OpenVMS Alpha | 9.1 TS1M3 SP4 | |||
| Tru64 UNIX | 9.1 TS1M3 SP4 | |||
A fix for this issue for SAS/ACCESS Interface to OLE DB 9.3_M2 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/K96.html#31997| Type: | Usage Note |
| Priority: |
| Date Modified: | 2008-07-29 08:39:41 |
| Date Created: | 2008-05-05 15:18:56 |