(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.
// 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
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.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
|