DatabaseLink`
DatabaseLink`

SQLBinary

SQLBinary[data]

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`"].

Examples

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: