NLS setting for Latin 1 and Latin 9 characters
Posted: Fri Sep 30, 2011 12:09 pm
What is the NLS setting to be used in parallel job to allow Latin 1 and Latin 9 characters while extracting and loading to SQL server 2005 Database.
We tried with option ISO-8859-1 , ISO-8859-15 , UTF-8 for NLS but there was no result,
When we tried with server job as mentioned in the below post, latin characters are visible but one or more normal english characters were replaced with some other special character
viewtopic.php?p=325808&sid=3d3a6229cd38 ... 101d665592
please help on this, we need to do the testing and release to production ASAP
We tried with option ISO-8859-1 , ISO-8859-15 , UTF-8 for NLS but there was no result,
When we tried with server job as mentioned in the below post, latin characters are visible but one or more normal english characters were replaced with some other special character
viewtopic.php?p=325808&sid=3d3a6229cd38 ... 101d665592
please help on this, we need to do the testing and release to production ASAP