NLS affecting column length to multiple?
Posted: Tue Jan 09, 2007 4:24 am
Hi all,
Has anyone encountered setting UTF-8 as the project default settings and whenever we use VARCHAR(UNICODE) or CHAR(UNICODE) datatype, the length of the columns created in Oracle is always multiply by 4. Btw, we are using Write Mode=Replace (creating tables thru DataStage).
Example,
DataStage: VARCHAR UNICODE (2)
Oracle: VARCHAR(8 BYTES)
I'm still finding out whether this is caused by Oracle or DataStage, anyone knows anything about this?![Sad :(](./images/smilies/icon_sad.gif)
Has anyone encountered setting UTF-8 as the project default settings and whenever we use VARCHAR(UNICODE) or CHAR(UNICODE) datatype, the length of the columns created in Oracle is always multiply by 4. Btw, we are using Write Mode=Replace (creating tables thru DataStage).
Example,
DataStage: VARCHAR UNICODE (2)
Oracle: VARCHAR(8 BYTES)
I'm still finding out whether this is caused by Oracle or DataStage, anyone knows anything about this?
![Sad :(](./images/smilies/icon_sad.gif)