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. SQL Server

--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    --  ----------------------------------------------------------------------------------------------
    --  IMPORTANT: To ensure backward compatibility, explicitly set the DefaultUtf8 property at the start of your application. 
    --  In a future major release, Chilkat will change the default value of DefaultUtf8 from 0 to 1

    --  To configure Chilkat to interpret and return strings as UTF-8, set the DefaultUtf8 property to 1. 
    --  Once set, the glob object can be discarded. The setting applies globally to all existing and future Chilkat objects.
    DECLARE @glob int
    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