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 | ||
A fix for this issue for SAS/ACCESS Interface to PC Files 9.21_M1 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/B06.html#38816
The following error is generated when you export double-byte SAS data to Microsoft Access tables: "WARNING: During insert: : Data value violated the schema for column (columname)."
| Type: | Problem Note |
| Priority: | high |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> MS Access |
| Date Modified: | 2010-02-23 11:59:48 |
| Date Created: | 2010-02-22 12:05:11 |