Special character in Target

chulett · Post by **chulett** » Thu Jul 03, 2008 7:17 am

First you need to determine how it got there, what the source was. This is typically caused by an NLS_LANG handling / conversion error during processing of the data.

keshav0307 · Post by **keshav0307** » Thu Jul 03, 2008 9:06 pm

can you change the NLS setting for job to UTF-8 and language ( may be AMERICAN)

arshi · Post by **arshi** » Sat Jul 05, 2008 6:52 am

I checked with UTF-8 option.Still its giving special character at the end of data.Any one have the solution for this.

Pankaj8904 · Post by **Pankaj8904** » Fri Jul 18, 2008 1:54 am

Hi Arshi,

You can use "ODBC Connector" stage for special characters.