Invalid Characters

mourya33 · Post by **mourya33** » Thu Apr 09, 2009 2:54 am

Im receiving the folloing warning while running a parallel job which loads data into oracle database from an oracle database:

main_program: Invalid character(s) ([xB0]) found converting string (code point(s): HOLD_TYPE_DESCRIPTION[x00][x00][x00][x00][x00][x00][x00][x00][x00][x00][x00][xB0][x09]![x08][x06][x00][x00][x00][x0A][x00]) from codepage UTF-8 to Unicode, substituting.

All the rows are getting loaded in the target without any rejections.Can anyone help me to avoid the warning?

Thanks in advance.
Mourya

ray.wurlod · Post by **ray.wurlod** » Thu Apr 09, 2009 7:16 am

How is this character getting into the data in the first place? It seems to me that prevention may be better than cure, if the field is simply intended to be space padded.