SQL Server

Get and Set the Email Subject

Demonstrates the Chilkat Email.Subject property, which reads or writes the MIME Subject header. When the subject contains non-ASCII characters, Chilkat performs the required MIME header encoding automatically. This example sets a subject and reads it back.

Background: MIME headers were originally restricted to plain ASCII, which is a problem for subjects containing accented letters, emoji, or non-Latin scripts. The solution (RFC 2047) is "encoded-words," where such text is wrapped like =?utf-8?B?...?= so it travels safely through mail systems. You work with the Subject property as ordinary readable text — Chilkat handles the encoding on the way out and the decoding on the way in.

Chilkat SQL Server Downloads

Download Chilkat for SQL Server

SQL Server

--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @sTmp0 nvarchar(4000)
    --  Demonstrates getting and setting the Email.Subject property, which reads or writes
    --  the MIME Subject header.  Chilkat performs the required MIME header encoding when the
    --  subject contains non-ASCII characters.

    DECLARE @email int
    EXEC @hr = sp_OACreate 'Chilkat.Email', @email OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    EXEC sp_OASetProperty @email, 'Subject', 'Meeting agenda for Monday'


    EXEC sp_OAGetProperty @email, 'Subject', @sTmp0 OUT
    PRINT 'Subject = ' + @sTmp0

    EXEC @hr = sp_OADestroy @email


END
GO