Page 1 of 1
Re: Multi byte characters getting rejected
Posted: Fri May 27, 2011 6:41 am
by chulett
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.
Re: Multi byte characters getting rejected
Posted: Fri May 27, 2011 7:08 am
by muralidwhds
We tried loading the same value in same field through Toad and worked fine.
Posted: Fri May 27, 2011 7:16 am
by chulett
So confirm for us the target field - does it show as VARCHAR2 50 BYTE or VARCHAR2 50 CHAR?
Posted: Fri May 27, 2011 7:53 am
by muralidwhds
In Database it's define as "ACCOUNT_NAME" VARCHAR2(50 CHAR),
In Datastage it's define VARCHAR2 (50)
Posted: Fri May 27, 2011 11:08 am
by arunkumarmm
Set you job level NLS to MS1252. It should work.
Posted: Fri May 27, 2011 3:02 pm
by ray.wurlod
Try using VarChar(150) in DataStage.