[fdo-trac] #643: Sqlite precision no handled on string data type
FDO
trac_fdo at osgeo.org
Wed May 5 10:29:08 EDT 2010
#643: Sqlite precision no handled on string data type
-----------------------------+----------------------------------------------
Reporter: bscott | Owner: traianstanev
Type: defect | Status: new
Priority: major | Milestone: 3.5.0
Component: SQLite Provider | Version: 3.5.0
Severity: 3 | Resolution:
Keywords: | External_id:
-----------------------------+----------------------------------------------
Comment (by bscott):
Thanks for the datatype documentation, it helps me a lot understanding
what's going on.
But wouldn't be a good idea to set the sqlite field type as something like
VARCHAR(PRECISION) or TEXT(PRECISION) even if the database won't issue any
error inserting,updating.
So FDO provider would be able to return the precision ( if specifyied ).
The reason why i'm asking is we use to do a describe on the table to know
how we should format the user input before inserting in the database.
--
Ticket URL: <http://trac.osgeo.org/fdo/ticket/643#comment:2>
FDO <http://fdo.osgeo.org/>
Feature Data Objects
More information about the fdo-trac
mailing list