The following SAS/ACCESS software can be used with a SAS UTF-8 session to support UTF-8 data in the database management system:

• SAS/ACCESS^® Interface to Oracle
• SAS/ACCESS^® Interface to DB2
• SAS/ACCESS^® Interface to SYBASE
• SAS/ACCESS^® Interface to INFORMIX
• SAS/ACCESS^® Interface to Teradata
• SAS/ACCESS^® Interface to ODBC
• SAS/ACCESS^® Interface to PC Files

To read UTF-8 characters from Oracle to SAS, you must configure the Oracle client software to transfer data from Oracle to SAS/ACCESS software in UTF-8 format. To do that, set the NLS_LANG environment variable (or the Windows registry key HKEY_LOCAL_MACHINE ► SOFTWARE ► ORACLE ► HOMEO ► NLS_LANG) to AMERICAN_AMERICA.AL32UTF8.

If you use a Japanese localized operating system, set the NLS_LANG value to JAPANESE_JAPAN.AL32UTF8.

Some limitations have been addressed in SAS Note 31024, "The limitations of accessing UTF-8 data in Informix."

Operating System and Release Information