Inserting data into Oracle DB using UTF 8

#1

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.

#2

what is your data source, Flat files?

#3

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.