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

dineshrk · Post by **dineshrk** » Mon May 24, 2010 11:30 pm

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.

ray.wurlod · Post by **ray.wurlod** » Tue May 25, 2010 12:01 am

Is this a binary (numeric) field that you're trying to read as a character string?

dineshrk · Post by **dineshrk** » Tue May 25, 2010 12:37 am

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? ...

ray.wurlod · Post by **ray.wurlod** » Tue May 25, 2010 2:32 am

What about in the source?

dineshrk · Post by **dineshrk** » Tue May 25, 2010 2:53 am

Sorce is also is of string type

ray.wurlod wrote:What about in the source? ...

ray.wurlod · Post by **ray.wurlod** » Tue May 25, 2010 5:05 am

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.