SUPPORT / SAMPLES & SAS NOTES
Problem Note 38816: Text fields can be truncated when you export double-byte SAS® data from SAS/ACCESS® Interface to PC Files to Microsoft Access tables
 |  |  |  |  |
Text fields can be truncated when you export Japanese, Chinese, Korean, and other double-byte SAS data to Microsoft Access tables. When this happens, the following error appears in the SAS log:
WARNING: During insert: : Data value violated the schema for column (columname)
The problem occurs because the double-byte length is not used when the the text field is created in Microsoft Access.
There is no workaround for this problem.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Note: You must use the second maintenance release of SAS® 9.2 (TS2M2) along with the hot fix. No hot fix is available for earlier releases of SAS 9.2.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to PC Files | Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS2M0 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft® Windows® for x64 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows XP Professional | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Windows Vista | 9.2 TS2M0 | 9.2 TS2M3 | ||