Documentation Source Text

Check-in [e4161dc6b1]
Login

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

Overview
Comment:Align the use of the "BLOB" affinity in lang_createtable.html with the definitions in datatype3.html.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | version-3.23
Files: files | file ages | folders
SHA3-256: e4161dc6b15860d3781aceb2973ec4b33e2333fddcdbb80d1e4f400e96ccee20
User & Date: drh 2018-04-06 12:16:00.544
Context
2018-04-07
11:54
Add "data transfer format" to the use cases for SQLite in the "When to Use" document. (check-in: d232f16b87 user: drh tags: version-3.23)
2018-04-06
12:16
Align the use of the "BLOB" affinity in lang_createtable.html with the definitions in datatype3.html. (check-in: e4161dc6b1 user: drh tags: version-3.23)
2018-04-04
00:56
Enhance the how-to-corrupt document to warn against carrying an open database connection across a fork(). (check-in: 516e342f08 user: drh tags: version-3.23)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/lang.in.
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944

<center><table border=1>
  <tr><th>Expression Affinity   <th>Column Declared Type
  <tr><td>TEXT                  <td>"TEXT"
  <tr><td>NUMERIC               <td>"NUM"
  <tr><td>INTEGER               <td>"INT"
  <tr><td>REAL                  <td>"REAL"
  <tr><td>NONE                  <td>"" (empty string)
</table></center>)^

<p>^(A table created using CREATE TABLE AS has no PRIMARY KEY and no
constraints of any kind. The default value of each column is NULL. The default
collation sequence for each column of the new table is BINARY.)^

<p>^Tables created using CREATE TABLE AS are initially populated with the







|







930
931
932
933
934
935
936
937
938
939
940
941
942
943
944

<center><table border=1>
  <tr><th>Expression Affinity   <th>Column Declared Type
  <tr><td>TEXT                  <td>"TEXT"
  <tr><td>NUMERIC               <td>"NUM"
  <tr><td>INTEGER               <td>"INT"
  <tr><td>REAL                  <td>"REAL"
  <tr><td>BLOB (a.k.a "NONE")   <td>"" (empty string)
</table></center>)^

<p>^(A table created using CREATE TABLE AS has no PRIMARY KEY and no
constraints of any kind. The default value of each column is NULL. The default
collation sequence for each column of the new table is BINARY.)^

<p>^Tables created using CREATE TABLE AS are initially populated with the