UNICODE for CHAR/ VARCHAR2 columns

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
FDW_CITI
Participant
Posts: 13
Joined: Sun Aug 31, 2008 10:18 pm

UNICODE for CHAR/ VARCHAR2 columns

Post by FDW_CITI »

Can anyone explains what this UNICODE signifies in column definitions.

We have defined the NLS Lang as UTF8 and all column datatype is VARCHAR2. We are using Oracle database for loading the data

Do we need to define the extended type as UNICODE?

Regards,
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

"Unicode" in the Extended property can mean a number of things, but most usually means that it can "talk" to data types NCHAR and NVARCHAR.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
FDW_CITI
Participant
Posts: 13
Joined: Sun Aug 31, 2008 10:18 pm

Post by FDW_CITI »

Thanks Ray.
Post Reply