sql server dts: Conversion of Oracle UTF-8 to SQL Server Unicode -- sql server dts

Conversion of Oracle UTF-8 to SQL Server Unicode

pdshotts NO[at]SPAM gmail.com
8/6/2006 5:18:40 AM

sql server dts:

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?

Re: Conversion of Oracle UTF-8 to SQL Server Unicode

Norman Kelm
8/6/2006 1:39:29 PM

I don't have any experience with this issue, but I have a few suggestions.

Perhaps you should change the connection to use the Microsoft OLEDB
Provider for Oracle, which is installed by default, or the Oracle
Provider for OLEDB, which is installed with the Oracle client. The OLEDB
providers may deal with UTF-8 more effectively.

Also look at the properties for the connection. On the All tab, there is
a property call Locale Identifier. Perhaps changing this from 1033 which
is US to some other value may help. Here is a web page with a list of
Locale Identifiers,
http://www.handheld-basic.com/documentation/text/page_1343.html

HTH,
Norman

get DTS Package Search at http://www.gerasus.com/

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.