Re: Conversion of Oracle UTF-8 to SQL Server Unicode
- From: Norman Kelm <norman@xxxxxxxxxxxxxxxxxxx>
- Date: Sun, 06 Aug 2006 13:39:29 GMT
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/
pdshotts@xxxxxxxxx wrote:
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?
- References:
- Conversion of Oracle UTF-8 to SQL Server Unicode
- From: pdshotts
- Conversion of Oracle UTF-8 to SQL Server Unicode
- Prev by Date: Conversion of Oracle UTF-8 to SQL Server Unicode
- Next by Date: Re: Returning value from SQL Task
- Previous by thread: Conversion of Oracle UTF-8 to SQL Server Unicode
- Index(es):
Relevant Pages
|
