Problem select database with brazilian portuguese chars

Help
,
1

Hello,

I have a problem select an oracle database. Our database holds data in brazilian portuguse, but when that data is read by the execute query activity, it gets truncated.
For examplo, I have a column with the word SUBCONTRATAÇÃO, but when I read it, it appears this way in the datatable: SUBCONTRATA��O

I researched a lot about encodings, tried to make changes to the oracle connection, the query, the database, but I can’t figure it out.

Does anyone have an idea on how to go about this issue?

Thanks!
Lucas