Database Mail sends as Base64 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Database Mail sends as Base64

Author

Topic

nathans
Aged Yak Warrior

938 Posts

Posted - 2009-02-10 : 15:09:37

Database Mail defaults to content encoding of Base64. This is fine, except when you need to send to an ancient text pager that only supports 8bit. I dont see an option to dictate the encoding type in sp_send_dbmail documentation. I am sending as 'TEXT' body_format.

You guys have any ideas how I might be able to get DB Mail to encode the body in 8bit instead?

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-02-10 : 16:03:42

I seriously doubt you'll be able to solve this in Database Mail. I'd instead suggest using a different email program to send the page or buy a newer pager. I realize this is not the answer you want, but think of the number of minutes/hours that have been spent researching this issue and then multiple that by your rate. The new pager pays for itself very quickly.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

nathans
Aged Yak Warrior

938 Posts

Posted - 2009-02-10 : 19:31:38

Thanks for the clarity Tara.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources