I am using DBI to connect to oracle and fetch data and write to a csv file. I am running this perl script in Linux.When i open the csv in windows, i could see some unsupported characters (inverted question mark).
To solve this issue and present the data as it is, i am using the following in environment variable setting
setenv NLS_LANG AMERICAN_AMERICA.WE8MSWIN1252
This has not worked. I think this is because the above NLS_LANG setting is only for windows.
Could you please help me if i can use a different NLS_LANG setting for linux to solve the issue with the unicode strings.