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

Details and Options

  • To use SQLBinary, you first need to load DatabaseLink using Needs["DatabaseLink`"].


Basic Examples  (1)

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 "DatabaseLink`DatabaseExamples`" package, as described in Using the Example Databases.

Open a connection:

Create a table with a column to store binary data:

Generate an image:

Represent the image as a string in GIF format:

Display the first few characters of the string:

Convert the string into a list of bytes wrapped in SQLBinary:

Insert the data:

Retrieve the data:

Convert the data back into a string:

Display the imported image: