Restricting floating point values in sqlite3

Question

I am using sqlite3 and I came across a strange issue. For example, I have the following table.

CREATE TABLE demo (effort integer);


insert into demo values (10.5);  - works fine
insert into demo values (10.5);  - works fine
insert into demo values (10.5555);  - works fine

I have two concerns:

1.Why is it allowing float values when I have declared the datatype to be integer not real ? 2.Is there any way, that I can restrict it upto 2 decimal places?

Is there any workaround so that I can restrict only integer values(strictly no floating values).

Please suggest.

CL. · Accepted Answer · 2013-04-25 14:11:04Z

1

SQLite uses dynamic typing.

To enforce the column type, add a constraint:

CREATE TABLE demo(
  effort INTEGER NOT NULL CHECK(typeof(effort) = 'integer')
)

answered Apr 25, 2013 at 14:11

CL.

182k18 gold badges241 silver badges282 bronze badges

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

Collectives™ on Stack Overflow

Restricting floating point values in sqlite3

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related