warning converting string code

raji33 · Post by **raji33** » Thu Jul 28, 2011 7:29 am

Hi All,

I Have a job which loads sqlserver to oracle table iam getting a warning as

"Invalid character(s) ([xC9]) found converting string (code point(s): CAF[xC9]) from codepage UTF-8 to Unicode, substituting"

Can anyone hwlp me out what exactly this warning meant by. Thanks!

Thanks

chulett · Post by **chulett** » Thu Jul 28, 2011 7:48 am

Basically, it means there was a character that it could not convert and the hexidecimal value of that character was "C9", hence the "[xC9]" in the message. Hex C9 is Decimal 201 if you want to go look that up in your source/target charactersets.

raji33 · Post by **raji33** » Thu Jul 28, 2011 8:18 am

I source charcterset is Project default (UTF-8)
Target characterset is Project default (UTF-8)

Do i need to change anything in there?

raji33 · Post by **raji33** » Thu Jul 28, 2011 9:52 am

All,

In target oracle stage under extended i have removed unicode and now its fine .