Conversion error warning

India2000 · Post by **India2000** » Sat Feb 20, 2016 5:39 pm

I have a scent ion where I extract fields from a table in varchar and fed them as char input to quality stage standardization stages. standardization out is char.

I getting the following error:
When checking operator: When binding output interface field USName to out filed USName : Implicit conversion from source type "ustring[max=1]" to result type "string[max=1]": Converting ustring to string using codepage UTF-8.
JOB aborts when warnings reach to 50.

How to resolve this issue?

Thanks in advance.

chulett · Post by **chulett** » Sat Feb 20, 2016 5:55 pm

Perhaps an explicit conversion is in order?

India2000 · Post by **India2000** » Sun Feb 21, 2016 9:45 am

Craig,

Could you be more specific? There is no explicit on conversion from varchar to char when extracting fields from the Table into a file being used as input to the standardization stage.
these are existing jobs.extract job is a server job output of which is given as input to quality stage job that is parallel.

We are migrating code from 8.1 to 9.1.

Any suggestion is highly appreciated.

chulett · Post by **chulett** » Sun Feb 21, 2016 3:51 pm

Thinking you may need to leverage the UstringtoString() function here.

ray.wurlod · Post by **ray.wurlod** » Sun Feb 21, 2016 3:55 pm

Or just enable the Unicode extension on your output field so that it, too, is data type ustring.