How to limit integer values to 16bit only in SQLite fields

Question

I am using sqlite DB with SQLite Expert personal as the Admin tool to design and add data.

My question is, how do I limit value of INT fields to a 16bit so that user cannot add number > 65535?

Please suggest any other better SQLite admin tool if what I am using is not great.

thanks

Joachim Isaksson · Accepted Answer · 2012-03-09 09:37:53Z

2

You can create the table in question with a constraint;

CREATE TABLE Test ( col1 INT, CONSTRAINT my_limit CHECK (col1<65536) );

which won't let you insert numbers larger than 65535 in that column. (you may want to remember to limit below 0 also if that's a requirement)

answered Mar 9, 2012 at 9:37

Joachim Isaksson

182k28 gold badges298 silver badges308 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

thanks a lot, that worked. Btw How do I limit strings to list of pre-defined values only?

@2ndlife Just create a constraint in the same way; create table Test (value varchar(32), CONSTRAINT my_limit CHECK (value='YES' OR value='NO'));