This short sample lets you convert any string data to Base64 directly in SQL stored procedure (SP written in MS T-SQL). The data are passed as a string, you can do String-to-binary conversion with specified charset (the default charset is specified by system locale). The binary data are converted by get_Base64 property.
See also ByteArray, T-SQL - base64 decoder for Microsoft SQL
|ByteArray, T-SQL - base64 encoder for Microsoft SQL|
/* Base64 encoder fot T-SQL */ CREATE PROCEDURE StringToBase64(@String VARCHAR(4000), @Base64 VARCHAR(4000) OUTPUT) AS DECLARE @ByteArray INT, @OLEResult INT EXECUTE @OLEResult = sp_OACreate 'ScriptUtils.ByteArray', @ByteArray OUT IF @OLEResult <> 0 PRINT 'ScriptUtils.ByteArray problem' --Set a charset if needed. --execute @OLEResult = sp_OASetProperty @ByteArray, 'CharSet', "windows-1250" --IF @OLEResult <> 0 PRINT 'CharSet problem' --Set the string. EXECUTE @OLEResult = sp_OASetProperty @ByteArray, 'String', @String IF @OLEResult <> 0 PRINT 'String problem' --Get base64 EXECUTE @OLEResult = sp_OAGetProperty @ByteArray, 'Base64', @Base64 OUTPUT IF @OLEResult <> 0 PRINT 'Base64 problem' EXECUTE @OLEResult = sp_OADestroy @ByteArray
Works with safearray binary data - save/restore binary data from/to a disk, convert to a string/hexstring, codepage/charset conversions, Base64 conversion, etc.
ByteArray is a COM class specially designed to work with Microsoft Windows Scripting engines - VB Script and JScript in Active Server Pages or WSH and in CHM or HTA applications. It also works with VB Net, Visual basic (VBA - VB 5, VB 6, Word, Excel, Access, …), C#, J#, C++, ASP, ASP.Net, Delphi and with T-SQL OLE functions - see Use ByteArray object article. You can also use the object in other programming environments with COM support, such is PowerBuilder.
Source code for ByteArray is available within distribution license, please see License page for ASP file upload and ScriptUtilities.
Huge ASP upload is easy to use, hi-performance ASP file upload component with progress bar indicator. This component lets you upload multiple files with size up to 4GB to a disk or a database along with another form fields. Huge ASP file upload is a most featured upload component on a market with competitive price and a great performance . The software has also a free version of asp upload with progress, called Pure asp upload , written in plain VBS, without components (so you do not need to install anything on server). This installation package contains also ScriptUtilities library. Script Utilities lets you create hi-performance log files , works with binary data , you can download multiple files with zip/arj compression, work with INI files and much more with the ASP utility.
© 1996 - 2014 Antonin Foller, Motobit Software | About, Contacts | (Find us on Google+)