MicrosoftHei
I'm trying to upload some data from oracle to SQL Server using this connector
the varchar2 sometimes is being mapped with DT_WSTR and sometimes with DT_STR
in oracle side we are trying to get data from a a view and from a table
on the view datatype of one of the columns is VARCHAR2(6 BYTE) and it is mapped with DT_WSTR which requires nvarchar on sql server
on the table the data type of a coulmin is VARCHAR2(6 BYTE) and it is mapped with DT_STR which requires varchar on sql server
the same connection from the same PC is used in both cases
is there any documentation on how this mappings are done?
or any indication on what should we look at to decide whether to use varchar or nvarchar on sql server
I'm trying to automate the process and I can't find any reason why one or the other datatype mapping is picked
