Hi, I'm creating a linked server in SQL Server 2008 R2 and linked to Oracle DB. Then I create a view to select data from Oracle via the linked server.
As I know, Oracle VARCHAR2 should be changed to VARCHAR in Sql Server. However, after the view creation, I found they become NVARCHAR. Why? Is there any way to let them auto change to VARCHAR?
asked Aug 24, 2011 at 06:46 PM in Default
It could be a correct behavior as Oracle VARCHAR2 can contain also multi-byte characters, and therefore the SQL Server chooses the NVARCHAR data type.
answered Aug 25, 2011 at 01:11 AM
We are working on migration project ,from Sql server 2005 Nvarchar(10) to Oracle 11g , what is similar data type and size , our assumption is oracle 11g is varchar2(10) is it correct? Please help me
answered Apr 15, 2013 at 04:26 AM