Print this page

"Black diamond question mark" character appears in a data extension instead of the correct character

Knowledge Article Number 000213209
Description
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 (�).
Resolution
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 Topic

What is a Query Activity?

 




promote demote