sqlsql-serverutf-8sql-server-2012sap

Error in collate SQL_Latin1_General_CP850_BIN2 with UTF-8 SQL Server


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


Solution

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