Page 1 of 1

UNICODE for CHAR/ VARCHAR2 columns

Posted: Thu Oct 02, 2008 11:40 pm
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,

Posted: Fri Oct 03, 2008 12:36 am
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.

Posted: Fri Oct 03, 2008 1:01 am
by FDW_CITI
Thanks Ray.