DSXchange

Posted: **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.

Posted: **Tue May 25, 2010 12:01 am**

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

Posted: **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? ...

Posted: **Tue May 25, 2010 2:32 am**

What about in the source?

Posted: **Tue May 25, 2010 2:53 am**

Sorce is also is of string type

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

Posted: **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.

DSXchange

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

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