Documentation Source Text

Check-in [d9afa1a3d7]
Login

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

Overview
Comment:Fix typo in the datatype3.html document.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: d9afa1a3d736d8b356a196eda3cef006ea4adccd
User & Date: drh 2010-02-11 15:55:22
Context
2010-02-12
18:34
Update the documentation to include information about the new secure_delete pragma. check-in: ae2879358d user: drh tags: trunk
2010-02-11
15:55
Fix typo in the datatype3.html document. check-in: d9afa1a3d7 user: drh tags: trunk
2010-02-09
23:25
Add an evidence mark to a statement in fts3.in. Add an evidence mark to a statement in fts3.in. check-in: 58746651dd user: dan tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/datatype3.in.

126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
the value is stored using the TEXT storage class. ^No
attempt is made to convert NULL or BLOB values.</p>

<p>^A string might look like a floating-point literal with
a decimal point and/or exponent notation but as long as
the value can be expressed as an integer, the NUMERIC affinity will convert
it into an integer. ^(Hence, the string '3.0e+5' is stored in a
column with NUMERIC affinity as the integer 30000, not as the floating
point value 300000.0.)^</p>

<p>^A column that uses INTEGER affinity behaves the same as a column
with NUMERIC affinity.  The difference between INTEGER and NUMERIC affinity
is only evident in a [CAST expression].</p>

<p>^A column with REAL affinity behaves like a column with NUMERIC







|







126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
the value is stored using the TEXT storage class. ^No
attempt is made to convert NULL or BLOB values.</p>

<p>^A string might look like a floating-point literal with
a decimal point and/or exponent notation but as long as
the value can be expressed as an integer, the NUMERIC affinity will convert
it into an integer. ^(Hence, the string '3.0e+5' is stored in a
column with NUMERIC affinity as the integer 300000, not as the floating
point value 300000.0.)^</p>

<p>^A column that uses INTEGER affinity behaves the same as a column
with NUMERIC affinity.  The difference between INTEGER and NUMERIC affinity
is only evident in a [CAST expression].</p>

<p>^A column with REAL affinity behaves like a column with NUMERIC