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?