Source of: /manual/en/sqlite.configuration.php
<?php
include_once $_SERVER['DOCUMENT_ROOT'] . '/include/shared-manual.inc';
$TOC = array();
$PARENTS = array();
include_once dirname(__FILE__) ."/toc/sqlite.setup.inc";
$setup = array (
'home' =>
array (
0 => 'index.php',
1 => 'PHP Manual',
),
'head' =>
array (
0 => 'UTF-8',
1 => 'en',
),
'this' =>
array (
0 => 'sqlite.configuration.php',
1 => 'Runtime Configuration',
),
'up' =>
array (
0 => 'sqlite.setup.php',
1 => 'Installing/Configuring',
),
'prev' =>
array (
0 => 'sqlite.installation.php',
1 => 'Installation',
),
'next' =>
array (
0 => 'sqlite.resources.php',
1 => 'Resource Types',
),
);
$setup["toc"] = $TOC;
$setup["parents"] = $PARENTS;
manual_setup($setup);
manual_header();
?>
<div id="sqlite.configuration" class="section">
<h2 class="title">Runtime Configuration</h2>
<p class="simpara">
The behaviour of these functions is affected by settings in <var class="filename">php.ini</var>.
</p>
<p class="para">
</p><table class="doctable table">
<caption><b>SQLite Configure Options</b></caption>
<thead valign="middle">
<tr valign="middle">
<th>Name</th>
<th>Default</th>
<th>Changeable</th>
<th>Changelog</th>
</tr>
</thead>
<tbody valign="middle" class="tbody">
<tr valign="middle">
<td align="left"><a href="sqlite.configuration.php#ini.sqlite.assoc-case" class="link">sqlite.assoc_case</a></td>
<td align="left">"0"</td>
<td align="left">PHP_INI_ALL</td>
<td align="left">Available since PHP 5.0.0.</td>
</tr>
</tbody>
</table>
<p>
For further details and definitions of the
PHP_INI_* modes, see the <a href="configuration.changes.modes.php" class="xref">Where a configuration setting may be set</a>.
</p>
<p class="para">Here's a short explanation of
the configuration directives.</p>
<p class="para">
</p><dl>
<dt id="ini.sqlite.assoc-case" class="varlistentry">
<span class="term">
<i><tt class="parameter">sqlite.assoc_case</tt></i>
<a href="language.types.integer.php" class="type int">int</a>
</span>
</dt><dd class="listitem">
<p class="para">
Whether to use mixed case (<i>0</i>), upper case
(<i>1</i>) or lower case (<i>2</i>) hash
indexes.
</p>
<p class="para">
This option is primarily useful when you need compatibility with other
database systems, where the names of the columns are always returned as
uppercase or lowercase, regardless of the case of the actual field names
in the database schema.
</p>
<p class="para">
The <span class="productname">SQLite</span> library returns the column names in their natural case (that
matches the case you used in your schema). When
<i><tt class="parameter">sqlite.assoc_case</tt></i>
is set to <i>0</i>
the natural case will be preserved. When it is set to
<i>1</i> or <i>2</i>, PHP will apply case
folding on the hash keys to upper- or lower-case the keys, respectively.
</p>
<p class="para">
Use of this option incurs a slight performance penalty, but is MUCH
faster than performing the case folding yourself using PHP script.
</p>
</dd>
</dl>
<p>
</p>
</div><?php manual_footer(); ?>
