Problem Note 40298: Microsoft Access text fields might contain trailing blanks when you use the ACCESSCS engine with SAS® 9.2 and UTF-8 encoding
 |  |  |  |  |
Text fields in Microsoft Access might contain extra trailing spaces when you export SAS data using the ACCESSCS engine. The problem occurs when you use a UTF-8 version of SAS. The extra spaces are required for double-byte characters such as those that occur in Asian languages (for example, Japanese, Chinese, or Korean).
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to PC Files | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS2M2 | |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS2M2 | |||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS2M2 | |||
| Microsoft® Windows® for x64 | 9.2 TS2M2 | |||
| Microsoft Windows Server 2003 for x64 | 9.2 TS2M2 | |||
| Microsoft Windows Server 2008 for x64 | 9.2 TS2M2 | |||
| Windows 7 Enterprise x64 | 9.2 TS2M2 | |||
| Windows 7 Professional x64 | 9.2 TS2M2 | |||
| Windows 7 Ultimate x64 | 9.2 TS2M2 | |||
| Windows Vista for x64 | 9.2 TS2M2 | |||
| 64-bit Enabled AIX | 9.2 TS2M2 | |||
| 64-bit Enabled HP-UX | 9.2 TS2M2 | |||
| 64-bit Enabled Solaris | 9.2 TS2M2 | |||
| HP-UX IPF | 9.2 TS2M2 | |||
| Linux | 9.2 TS2M2 | |||
| Linux for x64 | 9.2 TS2M2 | |||
| Solaris for x64 | 9.2 TS2M2 | |||
A fix for this issue for SAS/ACCESS Interface to ODBC 9.3_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/J13.html#40298A fix for this issue for SAS/ACCESS Interface to PC Files 9.3_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/G31.html#40298| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2013-09-06 14:19:39 |
| Date Created: | 2010-07-09 13:00:07 |