Page 1 of 1

Invalid Characters

Posted: Thu Apr 09, 2009 2:54 am
by mourya33
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

Posted: Thu Apr 09, 2009 7:16 am
by ray.wurlod
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.