Varchar2 and nvarchar2 --- Informatica driver option

Difference b/w varchar2 and nvarchar2:




varchar2 -- stores data in the databases base character set

nvarchar2 -- stores data in the national character set



Now we could have a column with data stored in 7 bit ascii and other column with

data stored in utf8 in the same database.

Rather than make everything multi-byte, we can just store the small amount of multi-byte(If required) within the same database.

Otherwise single byte data is simple, fixed width, smaller & faster.



Enable the below option if you are using Informatica’s Data Direct Driver to read the exact database data type. ( To retain Varchar2 and char2 )

Informatica by default treats all the string data types to multi-byte, example varachar2 will be nvarchar2 in Informatica.