NLS affecting column length to multiple?

krystlecsy · Post by **krystlecsy** » 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?

ray.wurlod · Post by **ray.wurlod** » Tue Jan 09, 2007 4:37 am

This very question was asked and answered TODAY. Doesn't your Search work?

krystlecsy · Post by **krystlecsy** » Tue Jan 09, 2007 6:08 am

oh, you're saying this one? sorry about that.

i will close this thread and refer to this thread instead.

viewtopic.php?t=106504

thanks, ray!