ByteArray - Store data with another charset (ibm850) to a database

Sample for ScriptUtils.ByteArray.HexString | Changes | Purchase | Download


     This sample works with a text data column in a database with any character set. For example, if you work with utf-8 in ASP, but you need to store data as an ibm850 charset in a database. If you have next table:

CREATE TABLE [dbo].[textTable] (
	[textColumn] [VARCHAR] (250) COLLATE SQL_AltDiction_CP850_CI_AI NULL 
but your ASP will work with utf-8, you need a binary conversion between utf-8 and ibm850.

ByteArray - Store data with another charset (ibm850) to a database 
<%@ Codepage=65001 %>

'set response charset to the same charset as the ASP page hase
' Codepage=65001 -> charset="utf-8", see ConvertCodePages

Response.CharSet = "utf-8"
Dim UnicodeString 
UnicodeString = Request.QueryString("text1")

'response.write "<br>UnicodeString:" & UnicodeString

'set the data to ByteArray object
Dim ByteArray
Set ByteArray = CreateObject("ScriptUtils.ByteArray")
ByteArray.CharSet = "ibm850"
ByteArray.String = UnicodeString
'ByteArray.ByteArray contains "ibm850" data now.

'Create an SQL command

SQL = "insert into TextTable (textColumn) values ( 0x" & ByteArray.HexString & ")"
'response.write "<br>" & SQL
'SQL = "Update TextTable set textColumn = 0x" & ByteArray.HexString
'SQL = SQL & " where Cond_Column=Cond_Value"

'The TextTable should be created as:
' CREATE TABLE [dbo].[textTable] (
'	[textColumn] [varchar] (250) COLLATE SQL_AltDiction_CP850_CI_AI NULL 

Set rConn = CreateObject("ADODB.Connection")
rConn.Open "connection to the SQL server"
rConn.Execute SQL 

 <input type="text" name="text1" value="" />
 <input type="submit" />

Other links for the ByteArray - Store data with another charset (ibm850) to a database sample


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 - 2011 Antonin Foller, Motobit Software | About, Contacts | e-mail:

Other Motobit links:   IISTracer, real-time IIS monitor   ASP file upload - upload files to ASP. 
ActiveX/VBSScript registry editor  ActiveX NT User account manager  Export MDB/DBF from ASP Active LogFile  Email export  ActiveX/ASP Scripting Dictionary object