"Black diamond question mark" character appears in a data extension instead of the correct character
|Knowledge Article Number||000213209|
Sometimes you may collect data from websites or upload data files into a data extension that uses a character not recognized by the character set used within Marketing Cloud. Instead of showing the character correctly, the character shows as question mark in a black diamond (�).
To fix the �, use the following query in a query activity to replace this character with a specific character or string of your choice:
Select replace([Field Name], nchar(65533) COLLATE Latin1_General_BIN, 'New Character/String') as [Field Name], from [Data Extension Name]
Related TopicWhat is a Query Activity?