Inserting data into Oracle DB using UTF 8

Question

How can we Insert data into Oracle table in UTF 8 character set . There is no option to write data in UTF8. Without UTF8, word MÉXICO  is inserted as M�ICO .
Can someone please help.

anubhav_nautiya · Answer

what is your data source, Flat files?

suresh_kumar_ro · Answer

Thanks for reply.
It reads data from Oracle db and Insert into Oracle db.
In Source table it is :- MÉXICO
While reading data from source db it’s showing as M�ICO. and same is inserted into target table.

Forum Discussion

Inserting data into Oracle DB using UTF 8

Recent Discussions

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?

Multipart Reader failure - 'content-type' was not found