Hi,
I have written a sql server procedure which sends the result of a query as a csv file via e-mail.
SQL server generates the attached file in UTF-8 BOM encoding.
I need the attached file to be generated in UTF-8 (without BOM).
I tried to change the encoding using the command:
EXEC msdb.dbo.sysmail_configure_sp 'DefaultAttachmentEncoding', 'UTF-8';
before the comand:
EXEC msdb.dbo.sp_send_dbmail
but it doesn't work.
Is there someone who can help me?
Many thanks.