10-06-2016 11:07 AM
I am getting incorrect characters in text fields when I request data from MS SQL Server using SAS Grid on Linux. Special characters such as ñ are showing up as Ã± and ó is coming out as Ã³. I do not get these errors when using WIndows PC SAS 9.4 requesting the same data from the same database. Any ideas on how to fix this from within SAS? I can look at my data using a SQL CLI on Linux and the characters look correct from there.
10-07-2016 04:44 AM
As @Ksharp writes highly likely the NLS_LANG setting in sasenv_local