Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add a note about data types and the compress/uncompress functions to the FTS documentation. |
|---|---|
| Downloads: | Tarball | ZIP archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
8fadbd41ce90f271ad003df64bcf09e9 |
| User & Date: | dan 2012-01-09 13:40:39.642 |
Context
|
2012-01-11
| ||
| 16:56 | Fix typos in the psow.html document. (check-in: e771d11d93 user: drh tags: trunk) | |
|
2012-01-09
| ||
| 13:40 | Add a note about data types and the compress/uncompress functions to the FTS documentation. (check-in: 8fadbd41ce user: dan tags: trunk) | |
|
2012-01-05
| ||
| 12:36 | Add mention of torn pages to the PSOW document. (check-in: 776ba1e766 user: drh tags: trunk) | |
Changes
Changes to pages/fts3.in.
| ︙ | ︙ | |||
1431 1432 1433 1434 1435 1436 1437 1438 1439 1440 1441 1442 1443 1444 |
<codeblock>
<i>-- Create an FTS4 table that stores data in compressed form. This</i>
<i>-- assumes that the scalar functions zip() and unzip() have been (or</i>
<i>-- will be) added to the database handle.</i>
CREATE VIRTUAL TABLE papers USING fts4(author, document, compress=zip, uncompress=unzip);
</codeblock>
<tcl>hd_fragment fts4prefix {FTS4 prefix option}</tcl>
<h2 tags="fts4 prefix option">Prefix</h2>
<p>
^The FTS4 prefix option causes FTS to index term prefixes of specified lengths
in the same way that it always indexes complete terms. ^The prefix option
must be set to a comma separated list of positive non-zero integers.
| > > > > > > > > > > | 1431 1432 1433 1434 1435 1436 1437 1438 1439 1440 1441 1442 1443 1444 1445 1446 1447 1448 1449 1450 1451 1452 1453 1454 |
<codeblock>
<i>-- Create an FTS4 table that stores data in compressed form. This</i>
<i>-- assumes that the scalar functions zip() and unzip() have been (or</i>
<i>-- will be) added to the database handle.</i>
CREATE VIRTUAL TABLE papers USING fts4(author, document, compress=zip, uncompress=unzip);
</codeblock>
<p>
When implementing the compress and uncompress functions it is important to
pay attention to data types. Specifically, when a user reads a value from
a compressed FTS table, the value returned by FTS is exactly the same
as the value returned by the uncompress function, including the data type.
If that data type is not the same as the data type of the original value as
passed to the compress function (for example if the uncompress function is
returning BLOB when compress was originally passed TEXT), then the users
query may not function as expected.
<tcl>hd_fragment fts4prefix {FTS4 prefix option}</tcl>
<h2 tags="fts4 prefix option">Prefix</h2>
<p>
^The FTS4 prefix option causes FTS to index term prefixes of specified lengths
in the same way that it always indexes complete terms. ^The prefix option
must be set to a comma separated list of positive non-zero integers.
|
| ︙ | ︙ |