BookmarkSubscribeRSS Feed
SSA1
Fluorite | Level 6

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.

1 REPLY 1
SASKiwi
PROC Star

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.

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1876 views
  • 2 likes
  • 2 in conversation