Documentation Source Text

Check-in [9b212044e0]
Login

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".
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 9b212044e0c309baaa594e2857c687bef5329e28285f962516de18b1fc775129
User & Date: drh 2018-01-13 14:33:17.365
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
Unified Diff Ignore Whitespace Patch
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>&nbsp;<td align=left>
<i>Not used.  Reserved for expansion.</i>





<tr><td valign=top align=center>N&#x2265;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&#x2265;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&#x2265;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&#x2265;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.
︙︙