5.9 Handling BLOB Data With Connector/Net

5.9.1 Preparing the MySQL Server
5.9.2 Writing a File to the Database
5.9.3 Reading a BLOB from the Database to a File on Disk

One common use for MySQL is the storage of binary data in BLOB columns. MySQL supports four different BLOB data types: TINYBLOB, BLOB, MEDIUMBLOB, and LONGBLOB, all described in The BLOB and TEXT Types and Data Type Storage Requirements.

Data stored in a BLOB column can be accessed using Connector/Net and manipulated using client-side code. There are no special requirements for using Connector/Net with BLOB data.

Simple code examples will be presented within this section, and a full sample application can be found in the Samples directory of the Connector/Net installation.