dbo_sqlite3 doesn't parse floats properly

[ghost]

Created by derrick, 7th Jul 2010. (originally Lighthouse ticket #12):

---

currently, the function column doesn't represent floats as all the possibilities sqlite3 understands

2.1 on http://www.sqlite.org/datatype3.html states that a float can be represented like such:

"If the declared type for a column contains any of the strings "REAL", "FLOA", or "DOUB" then the column has REAL affinity." meaning it's considered a float.

therefore the last conditional needs to be updated to

if (strpos($col, 'numeric') !== false || strpos($col, 'decimal') !== false || strpos($col, 'real') !== false || strpos($col, 'doub') !== false) {

please can this last condition be updated to reflect this

thanks