Donate Share

SQLite Database Browser

Tracker: Feature Requests

5 Add 'strict' option to enforce field types in data entry - ID: 2528410
Last Update: Tracker Item Submitted ( mikewhit )

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.


Mike Whittaker ( mikewhit ) - 2009-01-22 12:05

5

Open

None

Nobody/Anonymous

None

None

Public


Comments




Log in to comment.

No follow-up comments have been posted.

Attached File

No Files Currently Attached

Change

No changes have been made to this artifact.