Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How are NCHAR, NVARCHAR, NTEXT, or MEMO data types mapped within the Oracle Server?

April 26, 2017Data mapped memo nText nvarchar Oracle server types

0

Posted

How are NCHAR, NVARCHAR, NTEXT, or MEMO data types mapped within the Oracle Server?

1 Answer

0

Posted

The Migration Workbench does not support the mapping of NCHAR, NVARCHAR, NTEXT, or MEMO data types from Microsoft SQL Server, Sybase Adaptive Server, or Microsoft Access to the NCHAR, NVARCHAR2, or NCLOB data types in an Oracle database. Instead, the default mapping for these data types is to CHAR, VARCHAR2, and CLOB in Oracle because these Oracle data types support Unicode and multi-byte character sets.