SQLBinary
This feature is not supported on the Wolfram Cloud.

SQLBinary[data]
represents raw binary data that can be stored in a database.

DetailsDetails

ExamplesExamplesopen allclose all

Basic Examples  (1)Basic Examples  (1)

In[1]:=
Click for copyable input

If you find that the examples in this section do not work as shown, you may need to install or restore the example database with the package, as described in Using the Example Databases.

Open a connection:

In[2]:=
Click for copyable input
Out[2]=
In[3]:=
Click for copyable input

Here is a plot:

In[4]:=
Click for copyable input
Out[4]=

This generates a string that contains the image in GIF format:

In[5]:=
Click for copyable input

This shows part of the string:

In[6]:=
Click for copyable input
Out[6]=

This converts the string into a list of bytes wrapped in SQLBinary:

In[7]:=
Click for copyable input

This inserts the data:

In[8]:=
Click for copyable input

This retrieves the data:

In[9]:=
Click for copyable input

This converts it back into a string:

In[10]:=
Click for copyable input

Here is the imported image:

In[11]:=
Click for copyable input
Out[11]=
In[12]:=
Click for copyable input
In[13]:=
Click for copyable input