Inserting data into Oracle DB using UTF 8

[suresh_kumar_ro]

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]

what is your data source, Flat files?

[suresh_kumar_ro]

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.