Due to SQLite's dynamic typing, trailing or leading spaces on a numeric
value will result in the data type of that value being seen as 'text' by
SQLite, despite the defined column type in the Schema being Numeric, and
despite the fact that if the field was READ as Numeric the correct value
would be returned.
It would be useful to have a 'strict' option in the SQLite database browser
settings which would enforce Schema type values during field value input.
(In this case it could, for example, trim whitespace from Numerics and
reject other non-numeric characters.)
This would help to ensure 'clean' data when the Database Browser was being
used as a basic data entry tool.
Nobody/Anonymous
None
None
Public
Copyright © 2009 Geeknet, Inc. All rights reserved. Terms of Use