Post reply

Can xp_sendmail send text files in ANSI text?

  • June 20, 2003 at 4:03 pm

    #81075

    Hello,

    Is it possible to control which encoding xp_sendmail uses for text files?

    I have a scheduled job that executes a stored procedure that uses xp_sendmail to send the results of a query in a text file to various users. The text file encoding is Unicode, which causes a formatting issue for Windows 9x & ME users.

    So, my question is: can I force xp_sendmail to send the text files in ANSI instead of Unicode?

    Any help would be greatly appreciated.

    Thanks in advance for you help.

  • June 23, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • June 24, 2003 at 10:19 am

    #462863

    I have found the solution!

    Microsoft has added another parameter to xp_sendmail called @ansi_attachment which can be set to TRUE. This then causes the text file to be sent as ANSI. BTW, this parameter was not listed in my Books Online. See the Microsoft site:

    http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q280720

    Edited by - john645 on 06/24/2003 11:35:42 AM

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply