I found DI jobs handle special characters(SBC case/DBC case) in different way.
let us use the word contains ？ and ‘?’ i.e. “abc”？“aa?aa”
supposing this word in a flat file.
the job structure is: flat file → Oracle table, then the target table would contain “？” without replacing it with ‘?’.
but if this word is in the Oracle table, the job structure is Oracle table → Oracle target table, then the target table does not contain “？” because of replacing SBC with DBC.
Anyone can tell me why these happened and how to avoid and keep consistent regardless of reading from file or db table.
Thanks in advance!
Jason[quote][/quote]
imsen (BOB member since 2008-03-07)