Using SQL Server sp_send_dbmail send meeting Invitation email, use the Select query result (iCalendar format) as attachments, specify the attachment file called "Invitation. Ics,"

Also no problem to send and receive all normal, attachment format (to test I wrote the content directly in the query),

Use Outlook to receive email, open the attachment you can set the calendar,

However, when using Yahoo or Gmail to receive mail, the attachment shows the plain text file, rather than meeting invitation, to download the attachment to the local, manual is sent to a Yahoo or Gmail again, as a result,

I will download the text file using notepad to open, the right content, use "save as" function, found that the character set encoding for "UTF - 16 LE",


When I put the file save as "utf-8 encoding, then will be sent as an attachment to a Yahoo or Gmail, can be used to save to the calendar,



excuse me: how to set up email attachments as "utf-8", so that Yahoo and Gmail to identify correctly? Or is there any other solutions?

Thank you very much!!!!!!