<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<title>SQL types with PDO_4D and PHP</title>
</head>
<body><div class="manualnavbar" style="text-align: center;">
<div class="prev" style="text-align: left; float: left;"><a href="pdo-4d.constants.html">Constants for PDO_4D</a></div>
<div class="next" style="text-align: right; float: right;"><a href="ref.pdo-4d.sql4d.html">SQL acceptable by 4D</a></div>
<div class="up"><a href="ref.pdo-4d.html">4D (PDO)</a></div>
<div class="home"><a href="index.html">PHP Manual</a></div>
</div><hr /><div id="pdo-4d.sqltypes" class="refentry">
<div class="refnamediv">
<h1 class="refname">SQL types with PDO_4D and PHP</h1>
<p class="verinfo">(No version information available, might only be in SVN)</p><p class="refpurpose"><span class="refname">SQL types with PDO_4D and PHP</span> — <span class="dc-title">SQL types with PDO_4D and PHP</span></p>
</div>
<div class="refsect1 description" id="refsect1-pdo-4d.sqltypes-description">
<p class="para">
<table class="doctable table">
<caption><strong>Supported SQL types</strong></caption>
<thead>
<tr>
<th>Type SQL 4D</th>
<th>Equivalent 4D</th>
<th>Note</th>
</tr>
</thead>
<tbody class="tbody">
<tr>
<td>ALPHA_NUMERIC</td>
<td>TEXT</td>
<td class="empty"> </td>
</tr>
<tr>
<td>VARCHAR</td>
<td>TEXT</td>
<td class="empty"> </td>
</tr>
<tr>
<td>TEXT</td>
<td>TEXT</td>
<td class="empty"> </td>
</tr>
<tr>
<td>TIMESTAMP</td>
<td>DATE</td>
<td class="empty"> </td>
</tr>
<tr>
<td>INTERVAL</td>
<td>HOUR</td>
<td class="empty"> </td>
</tr>
<tr>
<td>DURATION</td>
<td>HOUR</td>
<td class="empty"> </td>
</tr>
<tr>
<td>BOOLEAN</td>
<td>BOOLEAN</td>
<td class="empty"> </td>
</tr>
<tr>
<td>BIT</td>
<td>BOOLEAN</td>
<td class="empty"> </td>
</tr>
<tr>
<td>BYTE</td>
<td>INT32</td>
<td class="empty"> </td>
</tr>
<tr>
<td>INT16</td>
<td>SMALLINT</td>
<td class="empty"> </td>
</tr>
<tr>
<td>SMALLINT</td>
<td>SMALLINT</td>
<td class="empty"> </td>
</tr>
<tr>
<td>INT32</td>
<td>INT32</td>
<td class="empty"> </td>
</tr>
<tr>
<td>INT</td>
<td>INT32</td>
<td class="empty"> </td>
</tr>
<tr>
<td>INT64</td>
<td>INT64</td>
<td class="empty"> </td>
</tr>
<tr>
<td>NUMERIC</td>
<td>INT64</td>
<td class="empty"> </td>
</tr>
<tr>
<td>REAL</td>
<td>REAL</td>
<td>Unsupported (use VARCHAR conversion)</td>
</tr>
<tr>
<td>FLOAT</td>
<td>FLOAT</td>
<td>Unsupported (use VARCHAR conversion)</td>
</tr>
<tr>
<td>DOUBLE PRECISION</td>
<td>FLOAT</td>
<td class="empty"> </td>
</tr>
<tr>
<td>BLOB</td>
<td>BLOB</td>
<td>Must use a prepared statement, and <strong><code>PDO::PARAM_LOB</code></strong></td>
</tr>
<tr>
<td>BIT VARYING</td>
<td>BLOB</td>
<td>Must use a prepared statement, and <strong><code>PDO::PARAM_LOB</code></strong></td>
</tr>
<tr>
<td>CLOB</td>
<td>TEXT</td>
<td class="empty"> </td>
</tr>
<tr>
<td>PICTURE</td>
<td>PICTURE</td>
<td>Must use a prepared statement, and <strong><code>PDO::PARAM_LOB</code></strong></td>
</tr>
</tbody>
</table>
</p>
</div>
</div><hr /><div class="manualnavbar" style="text-align: center;">
<div class="prev" style="text-align: left; float: left;"><a href="pdo-4d.constants.html">Constants for PDO_4D</a></div>
<div class="next" style="text-align: right; float: right;"><a href="ref.pdo-4d.sql4d.html">SQL acceptable by 4D</a></div>
<div class="up"><a href="ref.pdo-4d.html">4D (PDO)</a></div>
<div class="home"><a href="index.html">PHP Manual</a></div>
</div></body></html>
