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 |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
e96456b379a17a1fe3a2e8c088802951 |
User & Date: | drh 2009-03-27 15:12:07.000 |
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 | 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 | | > | 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> |
︙ | ︙ |