Invalid character conversion found - warning

dsuser_cai · Post by **dsuser_cai** » Wed Sep 16, 2009 12:51 pm

Hi Im using ODBC stage to extract sata from oracle table, all the fields are varchar, still im getting this warning mesage:

ODBC_Enterprise_144,0: Invalid character conversion found converting to ASCL_ASCII, substituting.

i tried a serach but couldnt get any help. please help me fix this.

ray.wurlod · Post by **ray.wurlod** » Wed Sep 16, 2009 5:36 pm

It usually tells you what the invalid character is (for example 0xBA or 0x8D). Did this occur in your case?

Sreenivasulu · Post by **Sreenivasulu** » Fri Sep 18, 2009 3:14 am

Hi Roy,

It occurs to me as well in the join stage. What should i do ?

Datawise it loads properly hence i have been ignoring it.

Regards
Sreeni

chulett · Post by **chulett** » Fri Sep 18, 2009 5:26 am

But as Ray noted, it should also be telling you "Invalid character conversion found converting XXX to ASCL_ASCII, substituting". Without that, we're completely punting in the dark.