microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Confused about encoding for SMTP

Subject: Re: Confused about encoding for SMTP
From: "Brent Horine"
Date: Tue, 30 Aug 2005 09:12:09 -0400
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Thanks for the suggestions Andy.

I changed all of the ' to ' but found no change.  The Timezone is set 
to GMT and regional settings are set to English US.

If I save the email in Outlook as .txt and open it in Notepad with the 
encoding set to ANSI, my subject line looks like

Subject:
敖瑮牵[...snip...]
Blah Blah Blah

Any clues?
TIA
Brent

"Andy" <[email protected]> wrote in message 
news:%[email protected]
>I do not have the exact answer, but just to confirm from your snippet 
>below, are you using ' or &apos;?
>
> Have you checked to ensure that your timezone is set properly on the SMTP 
> server and NS server?
>
> This may not be any answers, but thought I would share what popped into my 
> mind.
>
> "Brent Horine" <[email protected]> wrote in message 
> news:%[email protected]
>> I'm running "NS 2.0 SP1 Std en" on Windows 2003 Server.  I'm sending 
>> alerts via the SMTP channel.  I got the basics working by adding the Mail 
>> Server role to the server using Manage Your Server.
>> Now I'm getting mail but the subject line is in Kanji when opened in 
>> Outlook, but the text is in english.  When I use webmail, the whole body 
>> is in Kanji.  Help!  What encoding should I be using?
>>
>> My appConfig file look like
>>
>>  <DeliveryChannel>
>>   <DeliveryChannelName>EmailChannel</DeliveryChannelName>
>>   <ProtocolName>SMTP</ProtocolName>
>>   <Arguments>
>>    <Argument>
>>     <Name>SmtpServer</Name>
>>     <Value>localhost</Value>
>>    </Argument>
>>    <Argument>
>>     <Name>Bod oding</Name>
>>     <Value>utf-8</Value>
>>    </Argument>
>>   </Arguments>
>>  </DeliveryChannel>
>>
>> My appADF file looks like:
>>
>>    <Protocol>
>>     <ProtocolName>SMTP</ProtocolName>
>>     <Fields>
>>      <Field>
>>       <FieldName>Subject</FieldName>
>>       <SqlExpression>Alert: '+CONVERT (NVARCHAR(30), 
>> GETDATE())</SqlExpression>
>>      </Field>
>>      <Field>
>>       <FieldName>BodyFormat</FieldName>
>>       <SqlExpression>'html'</SqlExpression>
>>      </Field>
>>      <Field>
>>       <FieldName>From</FieldName>
>>       <SqlExpression>'[email protected]'</SqlExpression>
>>      </Field>
>>      <Field>
>>       <FieldName>Priority</FieldName>
>>       <SqlExpression>'Normal'</SqlExpression>
>>      </Field>
>>      <Field>
>>       <FieldName>To</FieldName>
>>       <SqlExpression>DeviceAddress</SqlExpression>
>>      </Field>
>>     </Fields>
>>    </Protocol>
>>
>> My XSLT file looks like:
>>
>> <?xml version="1.0" encoding="UTF-8" ?>
>> <xsl:stylesheet version="1.0" 
>> xmlns:xsl="http://www.w3.org/1999/XSL/Transform";>
>>
>> <xsl:template match="notifications">
>> <html>
>>  <head><title>Alert</title></head>
>>  <body>
>>   <xsl:apply-templates/>
>>   <i>Alert provided by VentureGPS.</i><br/><br/>
>> </body>
>> </html>
>> </xsl:template>
>>
>> <xsl:template match="notification">
>>  <B><xsl:value-of select="VehicleName" /></B> was speeding at 
>> <B><xsl:value-of select="Speed" /> MPH</B>
>>  at <xsl:value-of select="EventDateTime" /> at <xsl:value-of 
>> select="Address" />!
>> <BR/><BR/>
>>
>> </xsl:template>
>>
>> </xsl:stylesheet>
>>
>
> 



<Prev in Thread] Current Thread [Next in Thread>