Conversion of Oracle UTF-8 to SQL Server Unicode

I have to load text data from an Oracle 9i database into a SQL Server
database. The Oracle database's language is defined as UTF-8, and
includes far-Eastern language characters (Korean, Chinese etc).
In my DTS package the Oracle database connection is "Microsoft ODBC
Driver for Oracle". The Transform Data Task does not seem to recognise
the UTF-8 format, and copies the text into the nvarchar columns in the
SQL Server database without conversion to Unicode.
Is there another type of connection that I can use where I can define
the source locale as UTF-8, or alternatively an ActiveX script that
will convert the UTF-8 characters to Unicode?

.

Relevant Pages

  • Re: Creating XML from an Oracle DB
    ... answer to what must be a FAQ when generating XML from Oracle but I ... an Oracle 9.2 database using DBMS_XMLQUERY and DBMS_LOB. ... Oracle's utf-8 support for the XML packages is shameful. ... You can determine your database's character set with this query: ...
    (perl.dbi.users)
  • Re: TimesTen and In Memory Databases.....
    ... Users must optimize the Times Ten Database besides the Oracle ... I have done a similar trick with MySQL ... language for loading data into the database (any database, MySQL, Oracle ...
    (comp.databases.oracle.server)
  • NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET both set to UTF8 ?
    ... I have a problem with Oracle 9.2.0.6.0 on Unix. ... Is it possible to set (when database is created) both parameters: ... NLS_NCHAR_CHARACTERSET as UTF-8 ...
    (comp.databases.oracle.server)
  • Re: What so special about PostgreSQL and other RDBMS?
    ... That's exactly the link the licence agreement for the database points to when it ... comes to what wecan expect for paying support. ... > "Oracle may provide additional releases or versions of its programs ... If the requirements are volatile I'd do a long term contract detailing what ...
    (comp.lang.php)
  • A cool DBA job wanted
    ... 7, Oracle 6, Sybase, SQL Server ... Proposed proactive database monitoring through ... strategies to administer remote Oracle databases ... Trained installation and support personnel in basic ...
    (comp.databases.oracle.server)