Source of: /manual/pt_BR/oci8.datatypes.php
<?php
include_once $_SERVER['DOCUMENT_ROOT'] . '/include/shared-manual.inc';
$TOC = array();
$PARENTS = array();
include_once dirname(__FILE__) ."/toc/book.oci8.inc";
$setup = array (
'home' =>
array (
0 => 'index.php',
1 => 'PHP Manual',
),
'head' =>
array (
0 => 'UTF-8',
1 => 'pt_BR',
),
'this' =>
array (
0 => 'oci8.datatypes.php',
1 => 'Supported Datatypes',
),
'up' =>
array (
0 => 'book.oci8.php',
1 => 'OCI8',
),
'prev' =>
array (
0 => 'oci8.connection.php',
1 => 'Connecting Handling',
),
'next' =>
array (
0 => 'ref.oci8.php',
1 => 'Funções OCI8',
),
'alternatives' =>
array (
),
);
$setup["toc"] = $TOC;
$setup["parents"] = $PARENTS;
manual_setup($setup);
manual_header();
?>
<div id="oci8.datatypes" class="chapter">
<h1>Supported Datatypes</h1>
<table class="doctable table">
<caption><strong>The driver supports the following types when binding parameters using
<span class="function"><a href="function.oci-bind-by-name.php" class="function">oci_bind_by_name()</a></span> function:</strong></caption>
<thead>
<tr>
<th>Type</th>
<th>Mapping</th>
</tr>
</thead>
<tbody class="tbody">
<tr>
<td><strong><code>SQLT_NTY</code></strong></td>
<td>Maps a native collection type from a PHP collection object,
such as those created by <span class="function"><a href="function.oci-new-collection.php" class="function">oci_new_collection()</a></span>.</td>
</tr>
<tr>
<td><strong><code>SQLT_BFILEE</code></strong></td>
<td>Maps a native descriptor, such as those created by
<span class="function"><a href="function.oci-new-descriptor.php" class="function">oci_new_descriptor()</a></span>.</td>
</tr>
<tr>
<td><strong><code>SQLT_CFILEE</code></strong></td>
<td>Maps a native descriptor, such as those created by
<span class="function"><a href="function.oci-new-descriptor.php" class="function">oci_new_descriptor()</a></span>.</td>
</tr>
<tr>
<td><strong><code>SQLT_CLOB</code></strong></td>
<td>Maps a native descriptor, such as those created by
<span class="function"><a href="function.oci-new-descriptor.php" class="function">oci_new_descriptor()</a></span>.</td>
</tr>
<tr>
<td><strong><code>SQLT_BLOB</code></strong></td>
<td>Maps a native descriptor, such as those created by
<span class="function"><a href="function.oci-new-descriptor.php" class="function">oci_new_descriptor()</a></span>.</td>
</tr>
<tr>
<td><strong><code>SQLT_RDD</code></strong></td>
<td>Maps a native descriptor, such as those created by
<span class="function"><a href="function.oci-new-descriptor.php" class="function">oci_new_descriptor()</a></span>.</td>
</tr>
<tr>
<td><strong><code>SQLT_NUM</code></strong></td>
<td>Converts the PHP parameter to a 'C' long type, and binds to
that value.</td>
</tr>
<tr>
<td><strong><code>SQLT_RSET</code></strong></td>
<td>Maps a native statement handle, such as those created by
<span class="function"><a href="function.oci-parse.php" class="function">oci_parse()</a></span> or those retrieved from other OCI queries.</td>
</tr>
<tr>
<td><strong><code>SQLT_CHR</code></strong> and any other type</td>
<td>Converts the PHP parameter to a string type and binds as a
string.</td>
</tr>
</tbody>
</table>
<table class="doctable table">
<caption><strong>The following types are supported when retrieving columns from a result set:</strong></caption>
<thead>
<tr>
<th>Type</th>
<th>Mapping</th>
</tr>
</thead>
<tbody class="tbody">
<tr>
<td><strong><code>SQLT_RSET</code></strong></td>
<td>Creates an oci statement resource to represent the cursor.</td>
</tr>
<tr>
<td><strong><code>SQLT_RDD</code></strong></td>
<td>Creates a ROWID object.</td>
</tr>
<tr>
<td><strong><code>SQLT_BLOB</code></strong></td>
<td>Creates a LOB object.</td>
</tr>
<tr>
<td><strong><code>SQLT_CLOB</code></strong></td>
<td>Creates a LOB object.</td>
</tr>
<tr>
<td><strong><code>SQLT_BFILE</code></strong></td>
<td>Creates a LOB object.</td>
</tr>
<tr>
<td><strong><code>SQLT_LNG</code></strong></td>
<td>Bound as SQLT_CHR, returned as a string</td>
</tr>
<tr>
<td><strong><code>SQLT_LBI</code></strong></td>
<td>Bound as <strong><code>SQLT_BIN</code></strong>, returned as a string</td>
</tr>
<tr>
<td>Any other type</td>
<td>Bound as <strong><code>SQLT_CHR</code></strong>, returned as a string</td>
</tr>
</tbody>
</table>
</div>
<?php manual_footer(); ?>
