In your python code in the connection string use utf8mb4 when loading data from your database for example suppose you are loading data from mysql : connection_string = f"mysql+pyodbc://@{dsn}?charset=utf8mb4"
when writing to oracle from python , please set the data type of objectname to nvarchar.