<HTML
><HEAD
><TITLE
>fbsql_set_lob_mode</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK
REL="HOME"
TITLE="PHP Manual"
HREF="index.html"><LINK
REL="UP"
TITLE="FrontBase Functions"
HREF="ref.fbsql.html"><LINK
REL="PREVIOUS"
TITLE="fbsql_select_db"
HREF="function.fbsql-select-db.html"><LINK
REL="NEXT"
TITLE="fbsql_set_transaction"
HREF="function.fbsql-set-transaction.html"><META
HTTP-EQUIV="Content-type"
CONTENT="text/html; charset=ISO-8859-1"></HEAD
><BODY
CLASS="refentry"
BGCOLOR="#FFFFFF"
TEXT="#000000"
LINK="#0000FF"
VLINK="#840084"
ALINK="#0000FF"
><DIV
CLASS="NAVHEADER"
><TABLE
SUMMARY="Header navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="3"
ALIGN="center"
>PHP Manual</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
><A
HREF="function.fbsql-select-db.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="function.fbsql-set-transaction.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><H1
><A
NAME="function.fbsql-set-lob-mode"
></A
>fbsql_set_lob_mode</H1
><DIV
CLASS="refnamediv"
><A
NAME="AEN24575"
></A
><P
> (PHP 4 >= 4.2.0)</P
>fbsql_set_lob_mode --
Set the LOB retrieve mode for a FrontBase result set
</DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN24578"
></A
><H2
>Description</H2
>bool <B
CLASS="methodname"
>fbsql_set_lob_mode</B
> ( resource result, string database_name)<BR
></BR
><P
>
Returns: <TT
CLASS="constant"
><B
>TRUE</B
></TT
> on success, <TT
CLASS="constant"
><B
>FALSE</B
></TT
> on error.
</P
><P
>
<B
CLASS="function"
>fbsql_set_lob_mode()</B
> 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.
<P
></P
><UL
><LI
><P
> FBSQL_LOB_DIRECT - LOB data is retrieved directly. When data
is fetched from the database with
<A
HREF="function.fbsql-fetch-row.html"
><B
CLASS="function"
>fbsql_fetch_row()</B
></A
>, 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.
</P
></LI
><LI
><P
> FBSQL_LOB_HANDLE - LOB data is retrieved as handles to the
data. When data is fetched from the database with
<B
CLASS="function"
>fbsql_fetch_row ()</B
>, 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'".
</P
></LI
></UL
>
</P
><P
> See also:
<A
HREF="function.fbsql-create-blob.html"
><B
CLASS="function"
>fbsql_create_blob()</B
></A
>,
<A
HREF="function.fbsql-create-clob.html"
><B
CLASS="function"
>fbsql_create_clob()</B
></A
>,
<A
HREF="function.fbsql-read-blob.html"
><B
CLASS="function"
>fbsql_read_blob()</B
></A
>, and
<A
HREF="function.fbsql-read-clob.html"
><B
CLASS="function"
>fbsql_read_clob()</B
></A
>.
</P
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
SUMMARY="Footer navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="function.fbsql-select-db.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="function.fbsql-set-transaction.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>fbsql_select_db</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="ref.fbsql.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>fbsql_set_transaction</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>
distrib
>
Mandriva
>
9.1
>
ppc
>
media
>
main
>
by-pkgid
>
0afeee9cca140e167a996902b9a677c5
>
files
>
606
