note 125069 deleted from sqlite3.construct by cmb
| From: | cmb@php.net | Date: | Tue, 02 Jun 2020 07:15:09 +0000 |
| Subject: | note 125069 deleted from sqlite3.construct by cmb | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-214709@lists.php.net to get a copy of this message | ||
Note Submitter: eslindsey at gmail dot com
----
From https://www.sqlite.org/datatype3.html:
> 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.**
(Emphasis mine.) This would seem to indicate that the sample code should say TEXT, not STRING,
right?