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!

Unicode to UTF8 conversion in ODI

Revanth TambisettyMay 19 2015 — edited May 20 2015

Hi guys,

I have a csv file with unicode data in it, im trying to convert it to UTF8 to load data properly into the table . i tried setting the encoding paramter in the jdbc connection as

jdbc:snps:dbfile?ENCODING=UTF8

The connection is successful, but i still see unicode data in the model, i tried using the CHARSET_ENCODING as well, but it does not recognise the UTF8 types. im using the file to sql lkm

Please advise

Thanks and Regards,

Revanth Tambisetty

This post has been answered by Revanth Tambisetty on May 20 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 17 2015

Added on May 19 2015

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

7 comments

1,972 views