BookmarkSubscribeRSS Feed
medhatmamdouh
Fluorite | Level 6

hi 

i have problem when i use run a code from sas studio

"insert into table values ('محمد')"

and i go to database oracle to check it i see it ????

however when i run the same statement from sqlplus it appear correctly at DB.

does any one have any idea?

2 REPLIES 2
Timmy2383
Lapis Lazuli | Level 10

You likely need to make sure that your SAS server/configuration and the Oracle DB  is set up for unicode support.

JuanS_OCS
Amethyst | Level 16

Hi,

 

as recommended, what you will need is support for UNICODE from the SAS configuration.

 

You can do this by adding it, by updating your binaries, and you can also do it manually by changing some files called sasv9.conf or sasv9_usermods.conf.

Please read the documentation below:

 

https://support.sas.com/resources/papers/Multilingual_Computing_with_SAS_94.pdf

https://support.sas.com/resources/papers/AddingAdditionalSASWorkspaceServerstoSupportMultipleEncodin...

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
  • 2 replies
  • 1469 views
  • 0 likes
  • 3 in conversation