<?xml version="1.0" encoding="windows-1252"?>
<node id="1008495" title="Problem with Unicode Characters while reading from oracle database in perl script" created="2012-12-12 07:13:03" updated="2012-12-12 07:13:03">
<type id="115">
perlquestion</type>
<author id="994049">
venu_hs</author>
<data>
<field name="doctext">
Hi Monks

&lt;p&gt; 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
&lt;/P&gt;

&lt;p&gt;

setenv NLS_LANG AMERICAN_AMERICA.WE8MSWIN1252

&lt;/p&gt;

&lt;p&gt;
This has not worked. I think this is because the above NLS_LANG setting is only for windows.
&lt;/p&gt;


&lt;p&gt;
Could you please help me if i can use a different NLS_LANG setting for linux to solve the issue with the unicode strings. 
&lt;/p&gt;

Thanks</field>
</data>
</node>
