Documentation Source Text
Check-in [d9afa1a3d7]
Not logged in

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

Overview
SHA1 Hash:d9afa1a3d736d8b356a196eda3cef006ea4adccd
Date: 2010-02-11 15:55:22
User: drh
Comment:Fix typo in the datatype3.html document.
Tags And Properties
Changes
hide diffs unified diffs patch

Changes to pages/datatype3.in

126 the value is stored using the TEXT storage class. ^No 126 the value is stored using the TEXT storage class. ^No 127 attempt is made to convert NULL or BLOB values.</p> 127 attempt is made to convert NULL or BLOB values.</p> 128 128 129 <p>^A string might look like a floating-point literal with 129 <p>^A string might look like a floating-point literal with 130 a decimal point and/or exponent notation but as long as 130 a decimal point and/or exponent notation but as long as 131 the value can be expressed as an integer, the NUMERIC affinity will convert 131 the value can be expressed as an integer, the NUMERIC affinity will convert 132 it into an integer. ^(Hence, the string '3.0e+5' is stored in a 132 it into an integer. ^(Hence, the string '3.0e+5' is stored in a 133 column with NUMERIC affinity as the integer 30000, not as the floating | 133 column with NUMERIC affinity as the integer 300000, not as the floating 134 point value 300000.0.)^</p> 134 point value 300000.0.)^</p> 135 135 136 <p>^A column that uses INTEGER affinity behaves the same as a column 136 <p>^A column that uses INTEGER affinity behaves the same as a column 137 with NUMERIC affinity. The difference between INTEGER and NUMERIC affinity 137 with NUMERIC affinity. The difference between INTEGER and NUMERIC affinity 138 is only evident in a [CAST expression].</p> 138 is only evident in a [CAST expression].</p> 139 139 140 <p>^A column with REAL affinity behaves like a column with NUMERIC 140 <p>^A column with REAL affinity behaves like a column with NUMERIC