Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | In datatypes explication, correct example details and link to file format page. |
---|---|
Downloads: | Tarball | ZIP archive | SQL archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA3-256: |
ce5c357d2981fbf757dc54a1e5c62045 |
User & Date: | larrybr 2022-01-08 21:36:27 |
Context
2022-01-22
| ||
18:22 | Take .param set... clarification from trunk (check-in: adc3b9348f user: larrybr tags: branch-3.37) | |
18:12 | In datatypes explication, correct example details and link to file format page. (check-in: b59c99c117 user: drh tags: branch-3.37) | |
2022-01-11
| ||
23:30 | Merge the documentation changes for the -> and ->> operators. (check-in: acc42ce623 user: drh tags: trunk) | |
14:09 | Update JSON documentation for the addition of the -> and ->> operators and because JSON functions are moved into the core. (Closed-Leaf check-in: f688a6b35c user: drh tags: json-in-core) | |
2022-01-08
| ||
21:36 | In datatypes explication, correct example details and link to file format page. (check-in: ce5c357d29 user: larrybr tags: trunk) | |
2022-01-07
| ||
01:10 | Fix a minor typo in the JSON function documentation. (check-in: 6757f3c805 user: drh tags: trunk) | |
Changes
Changes to pages/datatype3.in.
︙ | ︙ | |||
27 28 29 30 31 32 33 | <p>Each value stored in an SQLite database (or manipulated by the database engine) has one of the following storage classes:</p> <ul> <li><p><B>NULL</B>. The value is a NULL value.</p> | | | | > | | > | 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 | <p>Each value stored in an SQLite database (or manipulated by the database engine) has one of the following storage classes:</p> <ul> <li><p><B>NULL</B>. The value is a NULL value.</p> <li><p><B>INTEGER</B>. The value is a signed integer, stored in 0, 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value.</p> <li><p><B>REAL</B>. The value is a floating point value, stored as an 8-byte IEEE floating point number.</p> <li><p><B>TEXT</B>. The value is a text string, stored using the database encoding (UTF-8, UTF-16BE or UTF-16LE).</p> <li><p><B>BLOB</B>. The value is a blob of data, stored exactly as it was input.</p> </ul> <p>A storage class is more general than a datatype. The INTEGER storage class, for example, includes 7 different integer datatypes of different lengths. <a href="fileformat2.html#record_format">This makes a difference on disk.</a> But as soon as INTEGER values are read off of disk and into memory for processing, they are converted to the most general datatype (8-byte signed integer). And so for the most part, "storage class" is indistinguishable from "datatype" and the two terms can be used interchangeably.</p> <p>^Any column in an SQLite version 3 database, except an [INTEGER PRIMARY KEY] column, may be used to store a value of any storage class.</p> |
︙ | ︙ |