Is necessary to specify a length of Integer when create a table in SQLITE? -


i understand if know length of value you'll receive must specify length. e.g. receive text string length of 20 always, specify when create table

my question is: i'll receive integers lengths may vary between 5 , 10, have put "mycolumnint integer (10)" -understanding prepare receive max length value- or leave "mycolumnint integer"?

from documentation:

integer. value signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on magnitude of value.

it enough define column having type integer. sqlite take care of rest.


Comments

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

php - How can I echo out this array? -