How to send Unicode symbols using SQL Server Database Mail?
Make sure you always use nvarchar as the data type throughout the whole flow, and always prefix Unicode strings with N. There is a big difference: