MTL Toolbox: Difference between revisions

No change in size ,  13 June 2025
m
{{TE| -> {{te|
m ({{TE| -> {{te|)
Line 67: Line 67:
Our full-text search is provided by the [[SQLite]] [https://sqlite.org/fts3.html FTS4] extension. We currently use the Standard Query Syntax. One of the three basic query types supported by FTS tables is "token or token prefix queries":
Our full-text search is provided by the [[SQLite]] [https://sqlite.org/fts3.html FTS4] extension. We currently use the Standard Query Syntax. One of the three basic query types supported by FTS tables is "token or token prefix queries":
* Specify a token prefix by appending an asterisk ('*') to the prefix. (While similar to {{w|wildcard character}} in [[zokgiap hexthorng|operating systems]], wildcard search is not currently supported by FTS)
* Specify a token prefix by appending an asterisk ('*') to the prefix. (While similar to {{w|wildcard character}} in [[zokgiap hexthorng|operating systems]], wildcard search is not currently supported by FTS)
** Example: {{TE|Taioa*}}, {{TE|臺*}}
** Example: {{te|Taioa*}}, {{te|臺*}}
* Specify a column-name followed by a colon (':')
* Specify a column-name followed by a colon (':')
** Example: {{TE|hj:頭*}} (returns entries where Taiwanese written with Harnji begins with character for [[thaau]])
** Example: {{te|hj:頭*}} (returns entries where Taiwanese written with Harnji begins with character for [[thaau]])
* Prefix the token with carat ('^') to require token to be very first token in its column
* Prefix the token with carat ('^') to require token to be very first token in its column
** Example: {{TE|^thaau}}
** Example: {{te|^thaau}}


Tokenizer: the default tokenizer ("simple") is used. Because it only does case folding of [[ASCII]] characters, [[Ø]] and ø do not match each other. Some words starting with Ø include {{TE|Ørciw}}, {{TE|Ørmngg}}, and {{TE|Ørtøexli}}.
Tokenizer: the default tokenizer ("simple") is used. Because it only does case folding of [[ASCII]] characters, [[Ø]] and ø do not match each other. Some words starting with Ø include {{te|Ørciw}}, {{te|Ørmngg}}, and {{te|Ørtøexli}}.


== See also ==
== See also ==
48,120

edits