Reading Binary Data from SQL Request
- To: mathgroup at smc.vnet.net
- Subject: [mg110353] Reading Binary Data from SQL Request
- From: Stephan Schiffels <stephan80 at mac.com>
- Date: Tue, 15 Jun 2010 02:28:12 -0400 (EDT)
I use DatabaseLink to retrieve binary data from a database.
So lets say, I retrieve the data as:
conn = OpenSQLConnection["myDB"];
data = SQLSelect[conn, "myTable", "myBinaryField"];
Then the type of data[[1,1]] is an SQLBinary-Object, containing a list of bytes, accessible as the first item of the SQLBinary-Wrapper: data[[1,1.1]]
I need to read this binary data as a sequence of double precision floating point numbers, similar to the following command:
BinaryRead[stream, "Real64"], where "stream" is a file on the harddisk.
I have not figured out how to do this with binary data that is already in memory, rather then in a file. All I can find in the documentation is concerned with File I/O.
What I can do is to use a temporary file:
num = BinaryRead["tmp", "Real64"];
But there clearly should be a way to avoid the creation of binary files here...
I appreciate any help.
Prev by Date:
Re: Using mathematica to read website
Next by Date:
Re: Can you tell me what is wrong with this program
Previous by thread:
Re: how to scale text to a bounding rectangle?
Next by thread:
Re: Reading Binary Data from SQL Request