Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Make it clear that the case_sensitive_like pragma installs a new application-defined LIKE function. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
e96456b379a17a1fe3a2e8c088802951 |
| User & Date: | drh 2009-03-27 15:12:07 |
Context
|
2009-03-31
| ||
| 12:52 | Documentation updates for version 3.6.12. (check-in: 03760bb55c user: drh tags: trunk) | |
|
2009-03-27
| ||
| 15:12 | Make it clear that the case_sensitive_like pragma installs a new application-defined LIKE function. (check-in: e96456b379 user: drh tags: trunk) | |
|
2009-03-23
| ||
| 08:29 | Update the last sentence of sharedcache.html to read "These restrictions were dropped in version 3.5.0.". (check-in: d1b5895b06 user: dan tags: trunk) | |
Changes
Changes to pages/pragma.in.
133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 |
pragma to check the cache size permanently.</p></li>
<tcl>Subsection case_sensitive_like</tcl>
<li><p><b>PRAGMA case_sensitive_like;
<br>PRAGMA case_sensitive_like = </b><i>0 | 1</i><b>;</b></p>
<p>The default behavior of the [LIKE] operator is to ignore case
for ASCII characters. Hence, by default <b>'a' LIKE 'A'</b> is
true. The case_sensitive_like pragma can be turned on to change
this behavior. When case_sensitive_like is enabled,
<b>'a' LIKE 'A'</b> is false but <b>'a' LIKE 'a'</b> is still true.</p>
</li>
<tcl>Subsection count_changes</tcl>
<li><p><b>PRAGMA count_changes;
<br>PRAGMA count_changes = </b><i>0 | 1</i><b>;</b></p>
|
| > |
133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 |
pragma to check the cache size permanently.</p></li>
<tcl>Subsection case_sensitive_like</tcl>
<li><p><b>PRAGMA case_sensitive_like;
<br>PRAGMA case_sensitive_like = </b><i>0 | 1</i><b>;</b></p>
<p>The default behavior of the [LIKE] operator is to ignore case
for ASCII characters. Hence, by default <b>'a' LIKE 'A'</b> is
true. The case_sensitive_like pragma installs a new application-defined
LIKE function that can change
this behavior. When case_sensitive_like is enabled,
<b>'a' LIKE 'A'</b> is false but <b>'a' LIKE 'a'</b> is still true.</p>
</li>
<tcl>Subsection count_changes</tcl>
<li><p><b>PRAGMA count_changes;
<br>PRAGMA count_changes = </b><i>0 | 1</i><b>;</b></p>
|