Documentation Source Text

Check-in [0b83b3cde9]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Update fts5 documentation to allow the subsitute character (codepoint 26) in unquoted query terms.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 0b83b3cde99206d7eebf7d5bb3ed1fd74f491e77
User & Date: dan 2015-10-07 16:44:36
Context
2015-10-07
18:25
Mention enhancements to dbstat in the change log. check-in: e738239518 user: drh tags: trunk
16:44
Update fts5 documentation to allow the subsitute character (codepoint 26) in unquoted query terms. check-in: 0b83b3cde9 user: dan tags: trunk
15:30
Add a fragment for "howtocompile" in the JSON1 documentation. check-in: de0fb99b82 user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/fts5.in.

172
173
174
175
176
177
178

179
180
181






182
183
184
185
186
187
188
       
       <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







>


|
>
>
>
>
>
>







172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
       
       <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).
         <li> The subsitute character (unicode codepoint 26).
       </ul>

       Strings that include any other characters must be quoted. Characters
       that are not currently allowed in barewords, are not quote characters and
       do not currently serve any special purpose in FTS5 query expressions may
       at some point in the future be allowed in barewords or used to implement
       new query functionality. This means that queries that are currently
       syntax errors because they include such a character outside of a quoted
       string may be interpreted differently by some future version of FTS5.
</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