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.
Log in to post a comment.