[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