4.5.6 Handling BLOB Data With Connector/NET

4.5.6.1 Preparing the MySQL Server

4.5.6.2 Writing a File to the Database

4.5.6.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 MySQL 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.