Usage Note 8102: Unable to load national character data in the 128-255 range correctly
into Oracle using SAS/ACCESS Interface to Oracle
When loading a SAS data set that contains national characters into
an Oracle table using PROC DBLOAD, the national characters appear to
translate incorrectly.
In one particular situation, it appeared that when loading characters in
the 128-255 range, they did not load correctly, even though the database
was set for the extended ASCII characters.
This is not a SAS problem. This problem is a result of not having the
Oracle environment variable NLS_LANG set, or having it set incorrectly.
To resolve this problem, have your DBA set the Oracle environment
variable NLS_LANG correctly.
Note: You may want to also check the ORA_NLS environment variable
setting to be sure it is set correctly.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to Oracle | Solaris | 8.2 TS2M0 | |
| 64-bit Enabled Solaris | 8.2 TS2M0 | |
| 64-bit Enabled AIX | 8.2 TS2M0 | |
| 64-bit Enabled HP-UX | 8.2 TS2M0 | |
| HP-UX | 8.2 TS2M0 | |
| AIX | 8.2 TS2M0 | |
| Tru64 UNIX | 8.2 TS2M0 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Usage Note |
| Priority: | |
| Topic: | SAS Reference ==> Procedures ==> ACCESS
|
| Date Modified: | 2002-08-01 13:16:57 |
| Date Created: | 2002-07-25 13:57:28 |
