<!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>Runtime Configuration</title>
</head>
<body><div class="manualnavbar" style="text-align: center;">
<div class="prev" style="text-align: left; float: left;"><a href="sqlite.installation.html">Installation</a></div>
<div class="next" style="text-align: right; float: right;"><a href="sqlite.resources.html">Resource Types</a></div>
<div class="up"><a href="sqlite.setup.html">Installing/Configuring</a></div>
<div class="home"><a href="index.html">PHP Manual</a></div>
</div><hr /><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">
<table class="doctable table">
<caption><strong>SQLite Configure Options</strong></caption>
<thead>
<tr>
<th>Name</th>
<th>Default</th>
<th>Changeable</th>
<th>Changelog</th>
</tr>
</thead>
<tbody class="tbody">
<tr>
<td><a href="sqlite.configuration.html#ini.sqlite.assoc-case" class="link">sqlite.assoc_case</a></td>
<td>"0"</td>
<td>PHP_INI_ALL</td>
<td>Available since PHP 5.0.0.</td>
</tr>
</tbody>
</table>
For further details and definitions of the
PHP_INI_* modes, see the <a href="configuration.changes.modes.html" 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">
<dl>
<dt id="ini.sqlite.assoc-case">
<span class="term">
<em><code class="parameter">sqlite.assoc_case</code></em>
<span class="type"><a href="language.types.integer.html" class="type int">int</a></span>
</span>
<dd>
<p class="para">
Whether to use mixed case (<em>0</em>), upper case
(<em>1</em>) or lower case (<em>2</em>) 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
<em><code class="parameter">sqlite.assoc_case</code></em> is set to <em>0</em>
the natural case will be preserved. When it is set to
<em>1</em> or <em>2</em>, 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>
</dt>
</dl>
</p>
</div><hr /><div class="manualnavbar" style="text-align: center;">
<div class="prev" style="text-align: left; float: left;"><a href="sqlite.installation.html">Installation</a></div>
<div class="next" style="text-align: right; float: right;"><a href="sqlite.resources.html">Resource Types</a></div>
<div class="up"><a href="sqlite.setup.html">Installing/Configuring</a></div>
<div class="home"><a href="index.html">PHP Manual</a></div>
</div></body></html>
