Multi byte characters getting rejected

chulett · Post by **chulett** » Fri May 27, 2011 6:41 am

muralidwhds wrote:Target field length is 50 Chars

Your database is using byte semantics and thus your target field length is 50 bytes long, not 50 characters. It won't fit, period. See if you can talk your DBA / Architect into switching semantics.

muralidwhds · Post by **muralidwhds** » Fri May 27, 2011 7:08 am

We tried loading the same value in same field through Toad and worked fine.

chulett · Post by **chulett** » Fri May 27, 2011 7:16 am

So confirm for us the target field - does it show as VARCHAR2 50 BYTE or VARCHAR2 50 CHAR?

muralidwhds · Post by **muralidwhds** » Fri May 27, 2011 7:53 am

In Database it's define as "ACCOUNT_NAME" VARCHAR2(50 CHAR),

In Datastage it's define VARCHAR2 (50)

arunkumarmm · Post by **arunkumarmm** » Fri May 27, 2011 11:08 am

Set you job level NLS to MS1252. It should work.

ray.wurlod · Post by **ray.wurlod** » Fri May 27, 2011 3:02 pm

Try using VarChar(150) in DataStage.

DSXchange

Multi byte characters getting rejected

Re: Multi byte characters getting rejected

Re: Multi byte characters getting rejected