In SAS^® 9.1, incorrect data might display when you use SAS/ACCESS Interface to ODBC to connect a SAS Unicode server (which is a SAS UTF-8 session) to a Unicode database. This can occur when you have national language data in Unicode on an English edition of Windows that is configured with an English locale. The incorrect data appears because the ODBC engine is not designed to enable Unicode processing.

To display Unicode data correctly, you need to change the Windows system locale so that it matches the language in which you are going to read. The SAS session locale must also be the same. For example, if your database stores Japanese data with UCS2 encoding, you need to change the Windows locale to Japanese. To to this, select Start ► Control Panel ► Regional and Language Options ► Advanced ► Japanese. You also need to set your SAS session locale to Japanese.

Select the Hot Fix tab in this note to access the hot fix for this issue. This hot fix enables you to use a SAS UTF-8 session to access Unicode in databases that are in an English-language working environment.

Beginning with SAS 9.2 Phase 2, SAS supports Unicode processing. Earlier editions of SAS 9.2 still need to apply the hot fix.

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at:

A fix for SAS 9.2 (TS1M0) for this issue is available at:

A fix for SAS 9.2 (TS1M0) with Asian Language Support (DBCS) for this issue is available at: