Description
bool
fbsql_set_lob_mode ( resource result, string database_name)
Returns: TRUE on success, FALSE on error_
fbsql_set_lob_mode() sets the mode for
retrieving LOB data from the database_ When BLOB and CLOB data is
stored in FrontBase it can be stored direct or indirect_ Direct
stored LOB data will always be fetched no matter the setting of
the lob mode_ If the LOB data is less than 512 bytes it will
always be stored directly_
FBSQL_LOB_DIRECT _ LOB data is retrieved directly_ When data
is fetched from the database with
fbsql_fetch_row(), and other fetch
functions, all CLOB and BLOB columns will be returned as
ordinary columns_ This is the default value on a new
FrontBase result_
FBSQL_LOB_HANDLE _ LOB data is retrieved as handles to the
data_ When data is fetched from the database with
fbsql_fetch_row (), and other fetch
functions, LOB data will be returned as a handle to the data
if the data is stored indirect or the data if it is stored
direct_ If a handle is returned it will be a 27 byte string
formatted as "@'000000000000000000000000'"_
See also:
fbsql_create_blob(),
fbsql_create_clob(),
fbsql_read_blob(), and
fbsql_read_clob()_