Oracle Libname: special chars

[MariaD]

Hi Folks,

I use some Oracle tables that I access from a libname (Access to Oracle). Some of my Oracle's tables has special characters inside (not in column or table name but in the data values). Por example, I have a column call City and inside has values like "São Paulo". When I access the table from Oracle client, I saw the value "São Paulo" correctly. But when access from SAS EG, the value appear something like "S?o Paulo".

There is any option I can use on libname statement to see the correct characters in SAS EG?

I undestand that the option PRESERVE_COLUMN_NAME is only when the problem is on columns name, not on the values. And the option PRESERVE_TAB_NAMES is only for problems with the name of the table.

Regards,

[VDD]

do you have your oracle schema = statement?

[s_lassen]

I thinl your problem is this: Problem Note 51411: Oracle special characters might be displayed as question marks (?) in SAS®.

And the solution (other than changing the codepage for your SAS session) is here: Usage Note 18688: Data in a local language other than English might not be displayed correctly when ...

[MariaD]

So to solves the problem I need to set the NLS_LANG environment variable in my SAS server, That is correct?

[s_lassen]

No, I think this refers to the Windows control panel. I cannot find the "advanced" tab in my own Windows control panel, but that may be because I am not administrator on my computer.