3

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

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Matheus Tramontini
  • 322
  • 1
  • 13
  • 1
    Assuming SQL_Latin1_General_CP850_BIN2 has all the characters you need, you probably have corrupt data. Cast the data as varbinary and examine the code points you actually have stored. – David Browne - Microsoft Jun 01 '18 at 14:49

1 Answers1

2

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

Nivaldo Neto
  • 123
  • 8