Documentation Source Text

Check-in [d2210cd43b]
Login

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
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: d2210cd43bf1b1d2609ae70a7c7c5995b145d78b
User & Date: dan 2015-05-20 18:20:11.264
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
Unified Diff Ignore Whitespace Patch
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>
    : ~ ! @ # $ % &#94; &amp; * ( ) + , =






</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
︙︙