====== updateBlobFile ======
~~NOTOC~~
<WRAP info>
Support for this function is limited. See the [[v5:database:feature_comparison|Feature Comparison Matrix]]
</WRAP>
<WRAP right box>
== Syntax ==
  mixed updateBlobFile(
      string $tableName,
      string $columnName,
      string $fileName,
      string $whereStatement,
      optional string $type='BLOB'
  )
</WRAP>


===== Description =====
The function ''updateBlobFile()'' updates a column specified by ''$columnName'' in an row of a table, specified by ''$tableName'' directly from a file on disk with a path specified by ''$fileName''. For BLOB files, the file is encoded in an appropriate manner before storage. No additional action is required.
<WRAP tip 300px>
The physical file must be resident on the server from which the script is run, not the workstation.
</WRAP>
===== $table =====
The table where the LOB is to be stored
===== $column =====
The column where the LOB is to be stored. The column should be of an appropriate type to store the data format required (see below)

===== $where=====
The $where statement should match a unique row in the table.
===== $type =====
The only acceptable values for $type are ''BLOB'' or ''CLOB''
-------------------------------
===== Usage =====
<code php>
/*
 * Connection assumed
 */
$tableName = 'images';
$columnName = 'image_data';

$fileName = '/temp/image.jpg';
$db->updateBlob($tableName,$columnName,$fileName,"ID=140")
</code>
===== Column Support For BLOB and CLOB =====
^Database^ CLOB ^ BLOB ^
^MetaType| X | B |
^MySQL| LONGTEXT| LONGBLOB |
^IBM DB2 | CLOB | BLOB(100M) |
^Oracle | CLOB | BLOB |
^SQL Server| TEXT | VARBINARY(MAX) |
^PostgreSQL | TEXT | BYTEA |
^SQLite | TEXT | BLOB |