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>
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.
- Source - SQL Server 2000 Database with a number of tables with NVARCHAR datatype
- Stored data is in Ge'ez language - it does mean that there is no standard locale.
- SQL Server internally is using UCS-2 to store Unicode data (compatible with UTF16)
- Target - Oracle 10g (10.2.0.4) Enterprise edition on Windows 2003 Server 32-bit
- NLS_CHARACTERSET = AL32UTF8
- NLS_NCHAR_CHARACTERSET=AL16UTF16
- 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-lReceived on Fri Nov 07 2008 - 09:39:13 CST