Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Update the file-format documentation on serial-types 10 and 11. They are no longer "reserved for expansion" but have shifted to "reserved for internal use". |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
9b212044e0c309baaa594e2857c687be |
| User & Date: | drh 2018-01-13 14:33:17 |
Context
|
2018-01-13
| ||
| 16:45 | Add a description of how UPDATE statements work to zipfile.in. check-in: 33a36d6b95 user: dan tags: trunk | |
| 14:33 | Update the file-format documentation on serial-types 10 and 11. They are no longer "reserved for expansion" but have shifted to "reserved for internal use". check-in: 9b212044e0 user: drh tags: trunk | |
| 00:03 | Clarification and typo fixes in the sqlite3_value_nochange() description within the xUpdate documentation. check-in: 92b3735966 user: drh tags: trunk | |
Changes
Changes to pages/fileformat2.in.
952 953 954 955 956 957 958 959 960 961 962 963 964 965 966 967 |
<tr><td valign=top align=center>7<td valign=top align=center>8<td align=left>
^Value is a big-endian IEEE 754-2008 64-bit floating point number.
<tr><td valign=top align=center>8<td valign=top align=center>0<td align=left>
^Value is the integer 0. (Only available for [schema format] 4 and higher.)
<tr><td valign=top align=center>9<td valign=top align=center>0<td align=left>
^Value is the integer 1. (Only available for [schema format] 4 and higher.)
<tr><td valign=top align=center>10,11
<td valign=top align=center> <td align=left>
<i>Not used. Reserved for expansion.</i>
<tr><td valign=top align=center>N≥12 and even
<td valign=top align=center>(N-12)/2<td align=left>
^Value is a BLOB that is (N-12)/2 bytes in length.
<tr><td valign=top align=center>N≥13 and odd
<td valign=top align=center>(N-13)/2<td align=left>
^Value is a string in the [text encoding] and (N-13)/2 bytes in length.
^The nul terminator is not stored.
|
| | > > > > > |
952 953 954 955 956 957 958 959 960 961 962 963 964 965 966 967 968 969 970 971 972 |
<tr><td valign=top align=center>7<td valign=top align=center>8<td align=left>
^Value is a big-endian IEEE 754-2008 64-bit floating point number.
<tr><td valign=top align=center>8<td valign=top align=center>0<td align=left>
^Value is the integer 0. (Only available for [schema format] 4 and higher.)
<tr><td valign=top align=center>9<td valign=top align=center>0<td align=left>
^Value is the integer 1. (Only available for [schema format] 4 and higher.)
<tr><td valign=top align=center>10,11
<td valign=top align=center><i>variable</i><td align=left>
<i>Reserved for internal use. These serial type codes will
never appear in a well-formed database file, but they
might be used in transient and temporary database files
that SQLite sometimes generates for its own use.
The meanings of these codes can shift from one release
of SQLite to the next.</i>
<tr><td valign=top align=center>N≥12 and even
<td valign=top align=center>(N-12)/2<td align=left>
^Value is a BLOB that is (N-12)/2 bytes in length.
<tr><td valign=top align=center>N≥13 and odd
<td valign=top align=center>(N-13)/2<td align=left>
^Value is a string in the [text encoding] and (N-13)/2 bytes in length.
^The nul terminator is not stored.
|