Question: Hi, I am trying to read data from a flat text file using ASP and convert it to Binary, before writing the binary to an MS SQL 2000 DB record.
I know how to read flat files using ASP and also how to write data to an MS SQL 2000 DB. However, I can't seem to find any information on converting ASCII data to Binary in ASP (NOT ASP.NET). Is this possible?
For example, I want to convert
Zmv/ix4T*+hT"U
to
01011010, 01101101, 01110110, 00101111, 01101001, 01111000, 00110100, 01010100, 00101010, 00101011, 01101000, 01010100, 00100010, 01010101
I have found some javascript code to do this via a form which can be seen here
JavaScript ASCII Converter but I don't think this will help as javascript is client side and ASP is server side.
I have read a little about using ADODB.Stream here
Convert a binary data (BinaryRead) to a string by VBS but do not really understand how I can use this.