Architecting, installing and maintaining your SAS environment

Cyrillic characters are not displayed correctly

Reply
New Contributor
Posts: 4

Cyrillic characters are not displayed correctly

Cyrillic characters are not displayed correctly when the user is connected to Oracle data base.

 

1)This issue happened after we updated this config file.
Cyrillic characters not displayed correctly in Oracle DB for below setup in sasv9.cfg.
And Cyrillic characters displayed correctly in Teradata DB for below setup in sasv9.cfg.
sasv9.cfg:
-ENCODING WCYRILLIC
-LOCALE RUSSIAN_RUSSIA
-DBCSTYPE NONE

 

2)User is able to see the Cyrillic Characters with below old configuration for Oracle DB.

Cyrillic characters displayed correctly in Oracle DB for below setup in sasv9.cfg.
And Cyrillic characters not displayed correctly in Teradata DB for below setup in sasv9.cfg.

Sasv9.cfg:
-LOCALE Russian
-ENCODING cyrillic

 

Can I get a help to update the sasv9.cfg to display the Cyrillic characters in both Oracle DB and Teradata DB.

Super User
Posts: 3,857

Re: Cyrillic characters are not displayed correctly

[ Edited ]

How are you viewing the external database tables? In SAS Enterprise Guide's data viewer or some other way? How are you creating the database connection in SAS? Using a LIBNAME statement? If this is the case then there is an OUTENCODING= option on the LIBNAME statement that you can try out to see if it helps.

Ask a Question
Discussion stats
  • 1 reply
  • 115 views
  • 2 likes
  • 2 in conversation