Difference between NVARCHAR in Oracle and SQL Server?
We are migrating some data from sql server to oracle. For columns defined
as NVARCHAR in SQL server we started creating NVARCHAR columns in Oracle
thinking them to be similar..But it looks like they are not.
I have read couple of posts on stackoverflow and want to confirm my findings.
Oracle VARCHAR2 already supports unicode if the database character set is
say AL32UTF8 (which is true for our case).
SQLServer VARCHAR does not support unicode. SQLServer explicitly requires
columns to be in NCHAR/NVARCHAR type to store data in unicode
(specifically in the 2 byte UCS-2 format)..
Hence would it be correct to say that SQL Server NVARCHAR columns
can/should be migrated as Oracle VARCHAR2 columns ?
No comments:
Post a Comment