ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:reference:connection:updateblobfile

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision		Previous revision
reference:updateblobfile [2015/08/05 03:14] – created mnewnhamv5:reference:connection:updateblobfile [2026/03/20 01:47] (current) – mnewnham
Line 2: Line 2:
 ~~NOTOC~~ ~~NOTOC~~
 <WRAP info> <WRAP info>
-Support for this function is limited. See the [[database:feature_comparison|Feature Comparison Matrix]]+Support for this function is limited. See the [[v5:database:feature_comparison|Feature Comparison Matrix]]
 </WRAP> </WRAP>
 <WRAP right box> <WRAP right box>
Line 17: Line 17:
  
 ===== Description ===== ===== 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''.+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> <WRAP tip 300px>
 The physical file must be resident on the server from which the script is run, not the workstation. The physical file must be resident on the server from which the script is run, not the workstation.
 </WRAP> </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===== ===== $where=====
-The where statement must match a row, or set of rows in the table.+The $where statement should match a unique row in the table.
 ===== $type ===== ===== $type =====
 The only acceptable values for $type are ''BLOB'' or ''CLOB'' The only acceptable values for $type are ''BLOB'' or ''CLOB''
Line 37: Line 42:
 $db->updateBlob($tableName,$columnName,$fileName,"ID=140") $db->updateBlob($tableName,$columnName,$fileName,"ID=140")
 </code> </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 |
 +
v5/reference/connection/updateblobfile.1438737245.txt.gz · Last modified: (external edit)