Print this page

"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:
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