Issue in extracting data with special character in different environments.

[SoumyaRanjanSahoo]

I have oracle database installed in two different environments. From one environment SAS reads the special character as it is.

But from other environment SAS behaves differently in reading the special character. Why ??

[Ksharp · Accepted solution]

Maybe these two Oracle have different encoding ?

[SoumyaRanjanSahoo]

Thanks xia