Unicode data migration from SQL Server to Oracle

From: Michael Rosenblum <mrosenblum_at_dulcian.com>
Date: Fri, 7 Nov 2008 10:39:13 -0500
Message-ID: <000401c940ee$fc8ca680$9300a8c0@dulcian.local>


Good morning, all!  

Currently we are building a system in Ethiopia - and as a part of the project need to do a data migration. So.  

  1. Source - SQL Server 2000 Database with a number of tables with NVARCHAR datatype
  2. Stored data is in Ge'ez language - it does mean that there is no standard locale.
  3. SQL Server internally is using UCS-2 to store Unicode data (compatible with UTF16)
  4. Target - Oracle 10g (10.2.0.4) Enterprise edition on Windows 2003 Server 32-bit
  5. NLS_CHARACTERSET = AL32UTF8
  6. NLS_NCHAR_CHARACTERSET=AL16UTF16
  7. Migration mechanism - Heterogeneous Services via ODBC

Problem - Unicode data comes to Oracle as '?'.  

And it is not a visual affectation:  

SQL> select ascii("Column1") a, "Column1" from test_at_db_link A Column1
--------- --------
63 ?
SQL>   Attempted actions:

1. OLEDB - the same problem
2. Third party ODBC drivers - don't even recognize NVARCHAR columns
3. Played with HS_LANGUAGE and HS_NLS_LANG - no impact.
 

Any ideas/suggestions?  

Thanks,
Michael Rosenblum
Dulcian Inc.    

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 07 2008 - 09:39:13 CST

Original text of this message