We are getting trouble when reading the data like ("â¦", "dóñez", etc) from a data file and storing into oracle DB, these are special characters and they must read and write into database as they are.
These following areas where we are getting the problems:
1) when we use split() function, theses characters are converted into like ['\xc3\xa2\xc2\xa6', 'd\xc3\xb3\xc3\xb1ez']
2) when I call database cursor execute for insert by using same data, the data inserted as "d����ez".
But when I directly used insert/update statement from SQL developer tool, the data correctly insterted/updated as we expected, but with python only we are getting the problems. What is the fix needed here, pelase advice