SQLite3 Integer Max Value

Question

1. what is the maximum value of data type INTEGER in sqlite3 ?
2. How do you store ip address in database ?
3. What is attached ?
4. How to create table which belongs to a specific database using sql ddl?
5. What is this error about ?

error while the list of system catalogue : no such table: temp.sqlite_master Unable to execute statement

1. Does sqlite3 text data type supoports unicode? Thanks.

Answer 1

1. Look at http://www.sqlite.org/datatype3.html Minimum is -(2⁶³) == -9223372036854775808 and maximum is 2⁶³ - 1 == 9223372036854775807
2. I would think you should use a varchar
3. http://www.sqlite.org/lang_attach.html
4. http://www.sqlite.org/lang_createtable.html
5. might be of help SQLite 'no such table' error

in general check out the sqlite documentation

Answer 2

INTEGER. The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value.

The INTEGER storage class, for example, includes 6 different integer datatypes of different lengths. This makes a difference on disk. But as soon as INTEGER values are read off of disk and into memory for processing, they are converted to the most general datatype (8-byte signed integer).

from http://www.sqlite.org/datatype3.html

Unless you have some other reason not to, you can store IP address using TEXT.