Page 1 of 1

Invalid character(s) ([xC0]) found converting string issue

Posted: Mon May 24, 2010 11:30 pm
by dineshrk
Hi,

I am getting the below warning while extracting data from sql db, for this i had enabled RCP. Please let me know whether it is related to data issue or i have to change any setting in my job.
Please find the below warning for reference.

Warning:
main_program: Invalid character(s) ([xC0]) found converting string (code point(s): NAMECONFIDENCESCORE[x00][x00][x00][x00][x00][x00][x00][x00][x00][x00][x00][x00][x00][xC0][xEB][xE4][x09][x09][x00]) from codepage UTF-8 to Unicode, substituting.

Posted: Tue May 25, 2010 12:01 am
by ray.wurlod
Is this a binary (numeric) field that you're trying to read as a character string?

Posted: Tue May 25, 2010 12:37 am
by dineshrk
Actually it is of string datatye.

NAMECONFIDENCESCORE: nullable string[3,padchar=' '];

ray.wurlod wrote:Is this a binary (numeric) field that you're trying to read as a character string? ...

Posted: Tue May 25, 2010 2:32 am
by ray.wurlod
What about in the source?

Posted: Tue May 25, 2010 2:53 am
by dineshrk
Sorce is also is of string type
ray.wurlod wrote:What about in the source? ...

Posted: Tue May 25, 2010 5:05 am
by ray.wurlod
Can you use another utility to display what's actually in the source in this particular field? If so, please post the result of that exercise.