Delphi: how to efficently read a big binary file, converting it to hexadecimal for passing it as a v

Posted by user193655 on Stack Overflow See other posts from Stack Overflow or by user193655
Published on 2010-05-12T08:10:00Z Indexed on 2010/05/12 8:14 UTC
Read the original article Hit count: 344

Filed under:

delphi

|

hexadecimal

|

file-read

|

sql-server

I need to convert a binary file (a zip file) into hexadecimal representation, to then send it to sql-server as a varbinary(max) function parameter.

A full example (using a very small file!) is:

1) my file contains the following bits 000011110000111

2) I need a procedure to QUICKLY convert it to 0F0F

3) I will call a sql server function passing 0x0F0F as parameter

The problem is that I have large files (up to 100MB, even if average file size is 100KB files are possible), so I need the fastest way to do this.

Otherwise stated: I need to create the string

'0x'+BinaryDataInHexadecimalRepresentation

in the most efficient way.

Related question: passing hexadecimal data to sql server

© Stack Overflow or respective owner

Related posts about delphi

TVirtualStringTree compatibility between Delphi 7 and Delphi 2010 - 'Parameter lists differ'

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I've made a form containing a TVirtualStringTree that works in Delphi 7 and Delphi 2010. I notice that as I move between the two platforms I get the message '...parameter list differ..' on the tree events and that the string type is changing bewteen TWideString (D7) and string (D2010). The only… >>> More
Convert Delphi 7 code to work with Delphi 2009

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a String that I needed access to the first character of, so I used stringname[1]. With the unicode support this no longer works. I get an error: [DCC Error] sndkey32.pas(420): E2010 Incompatible types: 'Char' and 'AnsiChar' Example code: //vkKeyScan from the windows unit var KeyString:… >>> More
Compile Delphi component package (bpl) for different Delphi versions

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello. The situation is the following. Typically I use RAD Studio 2010 for Delphi development. I have some components I would like to redistribute in binary form (*.bpl without source). But I would like people to be able to use them despite of their Delphi version. But, for example, dcu files can… >>> More
Book recommendation for moving from Delphi 6 to Delphi 2010

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am a long time Delphi 6 developer. Looking for a book on Delphi 2010. Not only on the new features available in Delphi 2010, but more importantly, guideline on how different it is to develop applications in Delphi 2010, the architecture, standard and convention, etc. Thanks a lot. >>> More
Delphi Speech recognition delphi

as seen on Stack Overflow - Search for 'Stack Overflow'
I need create a programatic equivalent using delphi language... or could someone post a link on how to do grammars in peech recogniton using the delphi. sorry for my english... XML Grammar Sample(s): <GRAMMAR>  <RULE NAME="HelloWorld"… >>> More

Related posts about hexadecimal

C#: How to parse a hexadecimal digit

as seen on Stack Overflow - Search for 'Stack Overflow'
Okay, I am working on a card playing program, and I am storing card values as hexadecimal digits. Here is the array: public int[] originalCards = new int[54] { 0x11, 0x12, 0x13, 0x14, 0x15, 0x16, 0x17, 0x18, 0x19, 0x1A, 0x1B, 0x1C, 0x1D, 0x21, 0x22, 0x23, 0x24, 0x25… >>> More
Converting binary to hexadecimal??

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey guys, Just wondering on how I would go about converting binary to hexadecimal?? Would I first have to convert the binary to decimal and then to hexadecimal?? For example, 101101001.101110101010011 How would I go about converting a complex binary such as the above to hexadecimal? Thanks in… >>> More
Problem reading hexadecimal buffer from C socket

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using the SDL_net sockets API to create a server and client. I can easily read a string buffer, but when I try to send hexadecimal data, recv gets the length, but I cannot seem to be a able to read the buffer contents. IPaddress ip; TCPsocket server,client; int bufSize = 1024; char message[bufSize]; int… >>> More
find the colour name from a hexadecimal colour code

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi , i want to find the name of a colour from the hexadecimal colour code. When i get a hex colour code i want to find the most matching colour name. for example for the code #c06040 , how to find out if it is a shade of brown, blue or yellow ?. so that i can find the colour of an object in the image… >>> More
jQuery jPicker users: hexadecimal returns 8 digit value?

as seen on Stack Overflow - Search for 'Stack Overflow'
I've just about got the jPicker script working flawlessly in my app. However, the value it returns contains 8 digits. Example: 212ebcff Is there a preset variable that forces jPicker to return a 6 digit hex value? >>> More