Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Setting content-transfer-encoding on notifications

Dotaz Setting content-transfer-encoding on notifications

  • Thursday, November 20, 2008 11:25 AM
     
     
    Sign In to Vote
    0

    Hello all

     

    Is it possible to change the content-transfer-encoding for notifications sent by Notification Services?

     

    I'm having issues delivering notifications to Blackberry devices with the content looking like:

    From: <xxx@xxx.com>
    Date: Wed, 23 Jul 2008 10:19:50 -0000
    To: <xxx@xxx.com>
    Subject: xxx


    㱨瑭氾ഊ†㱨敡搾ഊ††㱍䕔䄠桴瑰ⵥ煵楶㴢䍯湴敮琭呹灥∠捯湴敮琽≴數琯桴浬㬠捨慲獥琽畴昭ㄶ∾ഊ††㱴楴汥㹃潭浵湩捡瑯爼⽴楴汥㸍ਠ‼⽨敡搾ഊ†㱢潤礠獴祬攽≦潮琭晡浩汹㩔慨潭愬⁁物慬Ⱐ䡥汶整楣愬⁳慮猭獥物昻景湴⵳楺攺ㄱ灸㭬楮攭桥楧桴㨱㕰砻∾ഊ††㱤楶⁳瑹汥㴢扯牤敲㨣䐴䐴䐴‱灸⁳潬楤㭢慣歧牯畮携⍆䙆䙆䘻睩摴栺㘰ば砻景湴ⵦ慭楬示呡桯浡Ⱐ䅲楡氬⁈敬癥瑩捡Ⱐ獡湳⵳敲楦㭦潮琭獩穥㨱ㅰ砻汩湥⵨敩杨琺ㄵ灸㬢㸼業朠獲挽≨瑴瀺⼯瘴煡⹣潭浵湩捡瑯牣潲瀮捯洯䥭术䕭慩氯䡥慤敲⹪灧∾㱤楶⁩搽≂潤礢⁳瑹汥㴢浡牧楮㨱ば砠㈰灸‱ば砠㈰灸㬢㸼業朠獲挽≨瑴瀺⼯瘴煡⹣潭浵湩捡瑯牣潲瀮捯洯䥭术䕭慩氯坥汣潭攮杩昢㸼瀠獴祬攽≭慲杩渭瑯瀺ㄸ灸㬢㸍ਉॄ敡爠䩯桮Ⰽਉ㰯瀾ഊ††††㱰㸍ਉु⁵獥爠慣捯畮琠桡猠扥敮⁲敳敲癥搠景爠祯甠睩瑨楮⁃潭浵湩捡瑯爬⁴漠慣瑩癡瑥⁹潵爠慣捯畮琠灬敡獥‍ਉ०潬汯眠瑨攠汩湫⁢敬潷⸠奯甠睩汬⁢攠慳步搠瑯⁣潮晩牭⁹潵爠湡浥⁡湤⁥浡楬⁡摤牥獳Ⱐ慳⁷敬氠慳⁣桯潳攠祯畲⁵獥牮慭攠慮搠灡獳睯牤⸍ਉ㰯瀾ഊ††††㱰㸼愠獴祬攽≣潬潲㨣㌳戸敤㬢⁨牥昽≨瑴瀺⼯瘴煡⹣潭浵湩捡瑯牣潲瀮捯洯偵扬楣⽕獥爯䅣瑩癡瑥⹡獰砿慣瑩癡瑩潮䥤㴸㍦愴ㅥ搭㙦㌹ⴴ㜱㤭㤷捥ⵦ㘴愷搵㍦昴ㄢ㸍ਉउ䍬楣欠桥牥⁴漠慣瑩癡瑥⁹潵爠慣捯畮琍ਉ़⽡㸼⽰㸍ਠ†††‼瀾ഊउ佮捥⁡捴楶慴敤Ⱐ祯甠捡渠瑨敮潧⁩渠瑯⁃潭浵湩捡瑯爠睩瑨⁹潵爠捨潳敮⁵獥牮慭攠慮搠灡獳睯牤⸍ਉ㰯瀾ഊ††††㱰㸍ਉ॒敧慲摳ഊ़⽰㸍ਠ†††‼瀾㱢㹔桥⁃潭浵湩捡瑯爠呥慭㰯戾㰯瀾ഊ†††㰯摩瘾ഊ†††㱤楶⁳瑹汥㴢扡捫杲潵湤㩴牡湳灡牥湴⁵牬⡨瑴瀺⼯瘴煡⹣潭浵湩捡瑯牣潲瀮捯洯䥭术䕭慩氯䙯潴敲䉧⹧楦⤠牥灥慴⵸㭨敩杨琺ㄶ灸㬢㸼⽤楶㸍ਠ††‼摩瘠楤㴢䙯潴敲∠獴祬攽≦潮琭捯汯爺⌴㐴戴挻景湴⵳楺攺㄰灸㭭慲杩渺㄰灸′ば砠㄰灸′ば砻汩湥⵨敩杨琺ㄳ灸㬢㸼業朠獲挽≨瑴瀺⼯瘴煡⹣潭浵湩捡瑯牣潲瀮捯洯䥭术䕭慩氯䱯杯䙯潴敲⹧楦∠獴祬攽≭慲杩渭扯瑴潭㨱ば砻∾㱤楶⁳瑹汥㴢晬潡琺汥晴㬢㸍ਠ††††‼瀾ഊउउउउ周攠䍯浭畮楣慴潲⁃潲灯牡瑩潮㱢爾ഊउउउउ䍹杮整⁗慹㱢爾ഊउउउउ剡楮瑯渠䉲楤来⁂畳楮敳猠偡牫㱢爾ഊउउउउ䑈㐠㕙儼扲㸍ਉउउउॕ湩瑥搠䭩湧摯洍ਉउउउ㰯瀾ഊ††††㰯摩瘾ഊ††††㱤楶⁳瑹汥㴢晬潡琺汥晴㭭慲杩渭汥晴㨳ば砻∾ഊ†††††㱰㸍ਉउउउ॔敬㨠⬴㐠⠰⤱㤱″〵‵㄰〼扲㸍ਉउउउॆ慸㨠⬴㐠⠰⤱㤱″〵‵㔰㘍ਉउउउ㰯瀾ഊ†††††㱰㸍ਉउउउ॥㨠㱡⁨牥昽≭慩汴漺獵灰潲瑀捯浭畮楣慴潲捯牰⹣潭∠獴祬攽≣潬潲㨣㌳戸敤㬢㹳異灯牴䁣潭浵湩捡瑯牣潲瀮捯洼⽡㸼扲㸍ਉउउउॷ㨠㱡⁨牥昽≨瑴瀺⼯睷眮捯浭畮楣慴潲捯牰⹣潭∠獴祬攽≣潬潲㨣㌳戸敤㬢㹷睷⹣潭浵湩捡瑯牣潲瀮捯洼⽡㸼⽰㸍ਠ†††‼⽤楶㸍ਠ†††‼摩瘠獴祬攽≣汥慲㩢潴栢㸼⽤楶㸍ਠ††‼⽤楶㸍ਠ†‼⽤楶㸍ਠ‼⽢潤社ഊ㰯桴浬㸍�

     

    Any suggetions?

     

    Kind regards,

    Mike Goldsmith

     

All Replies

  • Monday, November 24, 2008 1:48 PM
    Moderator
     
     
    Sign In to Vote
    0
    What are you using to format the notifications? Is it an XSLT file? If so, what encoding have you specified?

    HTH...

    Joe

     
  • Monday, November 24, 2008 2:03 PM
     
     
    Sign In to Vote
    0

    Hi Joe

     

    Yes, we are using XSLT files and have the encoding set to UTF-8.

     

    Here's an exmaple of our template:

     

    Code Snippet

    <?xml version="1.0" encoding="utf-8" ?>

    <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

    <xsl:output method="html" omit-xml-declaration="yes" />

     

    <xsl:variable name="Host">localhost/App</xsl:variable>

     

    <xsl:template match="notifications">

    <html>

    <head>

    <title>Communicator</title>

    </head>

    <body style="font-family:Tahoma, Arial, Helvetica, sans-serif;font-size:11px;line-height:15px;">

    <div style="border:#D4D4D4 1px solid;background:#FFFFFF;width:600px;font-family:Tahoma, Arial, Helvetica, sans-serif;font-size:11px;line-height:15px;">

    <img src="http://{$Host}/Img/Email/Header.jpg" />

    <div id="Body" style="margin:10px 20px 10px 20px;">

    <xsl:apply-templates/>

    </div>

    <div style="background:transparent url(http://{$Host}/Img/Email/FooterBg.gif) repeat-x;height:16px;">

    </div>

    <div id="Footer" style="font-color:#444b4c;font-size:10px;margin:10px 20px 10px 20px;line-height:13px;">

    <img src="http://{$Host}/Img/Email/LogoFooter.gif" style="margin-bottom:10px;" />

    <div style="float:left;">

    <p>

    The Communicator Corporation<br />

    Cygnet Way<br />

    Rainton Bridge Business Park<br />

    DH4 5QY<br />

    United Kingdom

    </p>

    </div>

    <div style="float:left;margin-left:30px;">

    <p>

    Tel: +44 (0)191 305 5100<br />

    Fax: +44 (0)191 305 5506

    </p>

    <p>

    e: <a href="mailto:support@communicatorcorp.com" style="color:#33b8ed;">support@communicatorcorp.com</a><br />

    w: <a href="http://www.communicatorcorp.com" style="color:#33b8ed;">www.communicatorcorp.com</a>

    </p>

    </div>

    <div style="clear:both"></div>

    </div>

    </div>

    </body>

    </html>

    </xsl:template>

    </xsl:stylesheet>

     

     

     

    Thanks,

     
  • Monday, January 05, 2009 1:06 PM
    Moderator
     
     
    Sign In to Vote
    0
    Is this only happening for the Blackberry devices? Or it is all email recipients? 
    Joe Webb, SQL Server MVP | http://weblogs.sqlteam.com/joew/
     
  • Monday, January 26, 2009 1:36 PM
    Moderator
     
     
    Sign In to Vote
    0
    Is this still an issue for you? Did you get it resolved?
    Joe Webb, SQL Server MVP | http://weblogs.sqlteam.com/joew/