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!

How to load special characters in oracle

2909852Jul 15 2015

Hi All,

I'm trying to load data from flat file to oracle database table using Informatica power center 9.1.0 and I have some special characters in source file. Data are loaded successfully without any errors but these special characters are loaded different way like

1) Planner Ã¢â‚¬â€œ loaded as Planner ��

2) HÃƒÂ¡irÃƒÂ©ch loaded as Hair��ch

While same flatfile loaded into another flatfile,data loaded correctly including special characters.So,I am unable to understand problem with database or informatica.

Source

Flat File - comma ',' delimited

Code page is defined as UTF-8 encoding of Unicode

Relational connection

I have tried by changing the code page while creating relational connection in Informatica to UTF-8, ISO 8859-1 Western European, MS Windows Latin 1 etc.,didn't work.

Informatica

Integration Service and Repo code page is defined as UTF8

Target

Oracle database

NLS_NCHAR_CHARACTERSET: AL16UTF16

NLS_CHARACTERSET: AL32UTF8

Thanks

Sai

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 12 2015

Added on Jul 15 2015

#business-intelligence-applications, #oracle

0 comments

988 views