editing SQLite integer column with string

Databases
1

I have a column “page” defined as an integer in my SQLite database.
I am using a recordset to update the page field, which works swimmingly, but I found I am able to update the field with non-integer values. I can (and should) limit what a user is able to enter into the field to only integer values, but I’m concerned about the fact I seem to be able to “corrupt” the data in my database without much effort…

Here is the DDL for this table:
CREATE TABLE Entries (
entryID INTEGER PRIMARY KEY AUTOINCREMENT,
indexID INTEGER,
entryAudTS TEXT,
lastName TEXT,
firstName TEXT,
MaidenName TEXT,
page INTEGER
);

Even editing the table directly with SQLiteStudio allows me to put non-integer data into the page field

Do I need to define this table differently if I really only want integer values in the page column?

2

Sqlite allows any data type in any column. That’s just the way it is.

3

SQLite does not use data types like other databases: http://www.sqlite.org/datatype3.html