Search code examples
t-sqlfreemarkerquoted-printable

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 original 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.

Solution

  • 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.