Documentation Source Text

Check-in [83a0bc6bb9]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Fix a serious bug in the specification of the file format: the serial types for BLOB and TEXT where reversed.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 83a0bc6bb964e5121be7ac8c6c377be36ecd2081
User & Date: drh 2011-01-05 21:46:18
Context
2011-01-12
22:22
Fix documentation typo pointed out on the mailing list. check-in: 1927e7c245 user: drh tags: trunk
2011-01-05
21:46
Fix a serious bug in the specification of the file format: the serial types for BLOB and TEXT where reversed. check-in: 83a0bc6bb9 user: drh tags: trunk
2010-12-29
04:52
Fix the order of the LIMIT and OFFSET clauses in some examples on fts3.html (LIMIT comes before OFFSET). check-in: d3fc079ba8 user: dan tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/fileformat2.in.

867
868
869
870
871
872
873
874
875
876
877
878

879
880
881
882
883
884
885
<tr><td valign=top align=center>9<td valign=top align=center>0<td align=left>
Integer constant 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>
A string in the database encoding and (N-12)/2 bytes in length.
The nul terminator is omitted.
<tr><td valign=top align=center>N&#x2265;13 and odd
    <td valign=top align=center>(N-13)/2<td align=left>
A BLOB that is (N-13)/2 bytes in length

</table></center>)^

<p>Note that because of the way varints are defined, the header size varint
and serial type varints will usually consist of a single byte.  The
serial type varints for large strings and BLOBs might extend to two or three
byte varints, but that is the exception rather than the rule. 
The varint format is very efficient at coding the record header.</p>







|
<


|
>







867
868
869
870
871
872
873
874

875
876
877
878
879
880
881
882
883
884
885
<tr><td valign=top align=center>9<td valign=top align=center>0<td align=left>
Integer constant 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>
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>
A string in the database encoding and (N-13)/2 bytes in length.
The nul terminator is omitted.
</table></center>)^

<p>Note that because of the way varints are defined, the header size varint
and serial type varints will usually consist of a single byte.  The
serial type varints for large strings and BLOBs might extend to two or three
byte varints, but that is the exception rather than the rule. 
The varint format is very efficient at coding the record header.</p>