Error in collate SQL_Latin1_General_CP850_BIN2 with UTF-8 SQL Server

Question

I'm trying to select a column from my database that has SAP's informations. But when I execute my select all my special characters as 'À Ê' are broken, for example:

TELECOMUNICAÃiES (INCLUI ASSIST-NCIA T+CNICA)

should be

TELECOMUNICAÇÕES (INCLUI ASSISTÊNCIA TÉCNICA)

Is there some way to resolve this using a cast or a convert functions?

OBS: All my tables are configured with SQL_Latin1_General_CP850_BIN2 as required of SAP, but the columns are varchar instead of nvarchar

Answer 1

Probably the data is corrupted because this collation is default in any Windows