ifx_blobinfile_mode

Synopsis

Returns

Void

Description

BLOB's in an table are stored as pointers the actual data. Depending on how the BLOB data was stored when created with ifx_create_blob() , it may either be stored in memory or as a file pointer. When extracting the BLOB data from a table using a SELECT statement, the BLOB data ca be retrieved using ifx_get_blob() . However, the BLOB may be stored in either mode. Setting the BLOB mode using this function, explicitly sets the type of BLOB returned.

A setting of 0 saves BLOBs in memory, a setting 1 saves BLOBs to file.

This setting can also be hard coded in the PHP initialisation file.

Version

Since version 3.0.4 and 4.0

Example

$db = ifx_connect("stores7@ol","informix","informix");

$query = "select id, blobfield from testparams";
$result = do_query($query, $db);

// blob stored in memory
ifx_setblobinfile_mode(0')


while ($row = ifx_fetch_row($result)) {
   printf("%s %s<BR>", $row["id"], ifx_get_blob($row["blobfield"]));
}

ifx_free_result($result);

ifx_close($db);