Is there a way to change the encoding from default 'UniCode' to UTF-8 while generating data attachments from sp_send_dbmail on SQL Server? I found that there used to be a flag 'ANSI_Attachment' to accomplish just that but it got removed in SP2... Not sure if it's true.
Asked
Active
Viewed 2,764 times
1 Answers
0
EXEC msdb.dbo.sysmail_configure_sp @parameter_name=N'DefaultAttachmentEncoding', @parameter_value=N'MIME', @description=N'Default attachment encoding'
Pavel Nefyodov
- 876
- 2
- 11
- 29
-
hey Pavel, thanks for you suggestion. what should i pass in the @parameter_value so it encodes it in UTF-8? i did try "UTF-8" but it still encodes the files incorrectly. thanks :) – android-developer Sep 06 '11 at 12:07
-
Did you try setting in your html attachment? – Pavel Nefyodov Sep 12 '11 at 09:19