Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Update the list of reserved characters in fts5.html. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
d2210cd43bf1b1d2609ae70a7c7c5995 |
| User & Date: | dan 2015-05-20 18:20:11 |
Context
|
2015-05-26
| ||
| 12:26 | Cherrypick several recent minor changes from trunk. check-in: 0f4cfe6cd0 user: drh tags: branch-3.8.10 | |
|
2015-05-23
| ||
| 02:44 | Start the change log for 3.8.11. check-in: b189725f2c user: drh tags: trunk | |
|
2015-05-20
| ||
| 18:20 | Update the list of reserved characters in fts5.html. check-in: d2210cd43b user: dan tags: trunk | |
|
2015-05-15
| ||
| 14:51 | Link from the ATTACH documentation page to the DETACH page. check-in: b3cbd71993 user: drh tags: trunk | |
Changes
Changes to pages/fts5.in.
159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 |
Within an FTS expression a <b>string</b> may be specified in one of two ways:
<ul>
<li> <p>By enclosing it in double quotes ("). Within a string, any embedded
double quote characters may be escaped SQL-style - by adding a second
double-quote character.
<li> <p>As a bareword that includes no whitespace or reserved characters,
and is not "AND", "OR" or "NOT" (case sensitive). Reserved characters
are:
<pre>
: ~ ! @ # $ % ^ & * ( ) + , =
</pre>
In other words, the top row of a regular US keyboard, the plus sign,
comma and colon characters. Strings that include any of these
characters must be quoted.
</ul>
<p>
FTS queries are made up of <b>phrases</b>. A phrase is an ordered list of
one or more tokens. A string is transformed into a phrase by passing it to
the FTS table tokenizer. Two phrases can be concatenated into a single
large phrase using the "+" operator. For example, assuming the tokenizer
|
| | | | | | | | | > > > > |
159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 |
Within an FTS expression a <b>string</b> may be specified in one of two ways:
<ul>
<li> <p>By enclosing it in double quotes ("). Within a string, any embedded
double quote characters may be escaped SQL-style - by adding a second
double-quote character.
<li> <p>As an FTS5 bareword that is not "AND", "OR" or "NOT" (case sensitive).
An FTS5 bareword is a string of one or more consecutive characters that
are all either:
<ul>
<li> Non-ASCII range characters (i.e. unicode codepoints greater
than 127), or
<li> One of the 52 upper and lower case ASCII characters, or
<li> One of the 10 decimal digit ASCII characters, or
<li> The underscore character (unicode codepoint 96).
</ul>
Strings that include any other characters must be quoted.
</ul>
<p>
FTS queries are made up of <b>phrases</b>. A phrase is an ordered list of
one or more tokens. A string is transformed into a phrase by passing it to
the FTS table tokenizer. Two phrases can be concatenated into a single
large phrase using the "+" operator. For example, assuming the tokenizer
|