(SQL Server) Set Default to utf-8 instead of ANSI

This example shows how to set the default charset (character encoding) to utf-8. By default, strings passed to Chilkat are interpreted as ANSI, and strings returned by Chilkat are ANSI. The Chilkat.Global.DefaultUtf8 property can be set to tell Chilkat that all strings passed in are utf-8, and to return all strings as utf-8.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    -- To tell Chilkat to use interpret passed-in strings as utf-8, and to return utf-8,
    -- simply set the DefaultUtf8 property = 1.
    -- The glob object may be discarded after setting the property.  The setting
    -- will apply to all existing Chilkat objects, and all Chilkat objects to be created afterwards.
    DECLARE @glob int
    -- Use "Chilkat_9_5_0.Global" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.Global', @glob OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    EXEC sp_OASetProperty @glob, 'DefaultUtf8', 1

    EXEC @hr = sp_OADestroy @glob


END
GO