Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | The FLOATING POINT datatype has INTEGER affinity due to the "INT" at the end of "POINT". Make this clear in the datatype3.html documentation file. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
5c8750d0ff8bb3fab74864b0f4d5b88e |
| User & Date: | drh 2009-12-30 18:17:58 |
Context
|
2009-12-31
| ||
| 14:47 | Clarifications on affinity handling in the datatype3.html document. check-in: e62a74f31a user: drh tags: trunk | |
|
2009-12-30
| ||
| 18:17 | The FLOATING POINT datatype has INTEGER affinity due to the "INT" at the end of "POINT". Make this clear in the datatype3.html documentation file. check-in: 5c8750d0ff user: drh tags: trunk | |
| 15:32 | Fix some typos in datatype3.html. check-in: 3da8351ec8 user: dan tags: trunk | |
Changes
Changes to pages/datatype3.in.
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
...
246
247
248
249
250
251
252
253
254
255
256
257
258
259
|
<td align="center">NONE <td align="center">3 <tr><td align="center" valign="top"> REAL<br> DOUBLE<br> DOUBLE PRECISION<br> FLOAT<br> FLOATING POINT <td align="center">REAL <td align="center">4 <tr><td align="center" valign="top"> NUMERIC<br> DECIMAL(10,5)<br> BOOLEAN<br> ................................................................................ DATE<br> DATETIME <td align="center">NUMERIC <td align="center">5 </table>)^ </blockquote> <h3>2.3 Column Affinity Behavior Example</h3> <p>The following SQL demonstrates how SQLite uses column affinity to do type conversions when values are inserted into a table.</p> ^(<blockquote> <pre> |
|
<
>
>
>
>
|
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
...
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
|
<td align="center">NONE <td align="center">3 <tr><td align="center" valign="top"> REAL<br> DOUBLE<br> DOUBLE PRECISION<br> FLOAT <td align="center">REAL <td align="center">4 <tr><td align="center" valign="top"> NUMERIC<br> DECIMAL(10,5)<br> BOOLEAN<br> ................................................................................ DATE<br> DATETIME <td align="center">NUMERIC <td align="center">5 </table>)^ </blockquote> <p>^Note that a declared type of "FLOATING POINT" would give INTEGER affinity, not REAL affinity, due to the "INT" at the end of "POINT". ^And the declared type of "STRING" has an affinity of NUMERIC, not TEXT. <h3>2.3 Column Affinity Behavior Example</h3> <p>The following SQL demonstrates how SQLite uses column affinity to do type conversions when values are inserted into a table.</p> ^(<blockquote> <pre> |