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
NLS setting for Latin 1 and Latin 9 characters
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 9
- Joined: Tue Feb 16, 2010 1:18 am
NLS setting for Latin 1 and Latin 9 characters
Regards,
Kannan
Kannan
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
We don't do "urgent" or "ASAP" here. DSXchange is an all-volunteer site whose members post as and when they can.
If it's urgent sign up with your official support provider for priority service, and learn just how expensive "urgent" can be.
If it's urgent sign up with your official support provider for priority service, and learn just how expensive "urgent" can be.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.