SQL Server

Detect the Primary Language Group of an Email

Demonstrates the read-only Chilkat Email.Language property, which identifies the primary language group detected in the email's subject and body text, returning values such as latin1, russian, or japanese. The Subject has the greatest influence on the result. This example sets English text and reads the detected language.

Background: This is a heuristic based on Unicode: every character belongs to a Unicode "block" (Latin, Cyrillic, Greek, CJK, etc.), and Chilkat classifies the message by which blocks its characters fall into. The goal is practical — choosing a suitable charset/encoding for the text — not formal linguistic detection. It does not read the MIME Content-Language header, and it ignores characters in address and other header fields.

Chilkat SQL Server Downloads

Download Chilkat for SQL Server

SQL Server

--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @sTmp0 nvarchar(4000)
    --  Demonstrates the read-only Email.Language property, a character-based
    --  heuristic that identifies the primary language group detected in the
    --  email's subject and body text (e.g. latin1, russian, japanese, ...).

    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', 'Hello, this is an English subject line.'
    EXEC sp_OASetProperty @email, 'Body', 'This is the body text, written in English.'

    --  The Subject has the greatest influence on the result.

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

    EXEC @hr = sp_OADestroy @email


END
GO