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 | SQL archive |
| Timelines: | family | ancestors | descendants | both | version-3.23 |
| Files: | files | file ages | folders |
| SHA3-256: |
e4161dc6b15860d3781aceb2973ec4b3 |
| User & Date: | drh 2018-04-06 12:16:00 |
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
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
|