Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Local Character Conversion using ODI

710478Sep 10 2009 — edited Sep 22 2009

Hi ODI guru's..

Need info on how to Interface Local Characters to SQL Server.

Requirement Background:

Source (Oracle) : Oracle stores data in UTF8 format
Target (SQL Server 2005): Data is stored in UTF16 Format in SQL Server

We have multi country language data in Source Table in oracle. While interfacing data we need to convert the data to UTF16 and then push to SQL Server in ODI.

Please throw some ideas on this..

I have tried CONVERT, UNISTR functions to send the data to SQL Server in UTF16 format but nothing worked out. Data is always interfaced as (????) or Inverted question marks. This seems to be junk data for me.

Any useful info is higly appreciated.

Regards,
Anil

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 20 2009

Added on Sep 10 2009

#business-intelligence-applications, #data-integrator, #odi, #oracle, #server, #sql, #system-management-and-integration

7 comments

1,844 views