开发者

Encode to Quoted-Printable in TSQL (or FreeMarker)?

I store the message part of lots of emails in an MsSql database. Before sending an email with the message I need to encode it into Quoted-Printable format. I don't encode it before saving it to db because I want to have the origi开发者_运维百科nal message. And I don't want to have both the original and the encoded one in the db.

I'm using third-party software for sending mails so my only options to encode the messages is when reading them from the database or to encode them in freemarker.

So, does anyone know how to encode the messages from TSQL or FreeMarker? Preferrably a solution that doesn't involve buying a license.


The options you have are as follows:

  1. select the original email from sql server and then encode it in client application.
  2. create an extended stored procedure or function using CLR.
  3. create a sql function without using CLR. In this case you will have to implement all the Quoted Printable rules. This solution would be really messy and may not be very efficient also.
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜