Sqlite & mysql field types?

Question

Hi, I'm working on my first sqlite project, and I'm just wondering if sqlite still supports the same field type as MYsql, like DATETIME, TINYINT, VARCHAR etc.

If sqlite supports a limited field type, it will be a great help if someone can provide me with them.

thank!

Answer 1

sqlite has a very limited number of data types. According to the documentation, it has the following 5 data types:

• A NULL . Value is the NULL value.
• INTEGER. , 1, 2, 3, 4, 6 8 .
• . , 8- IEEE.
• . , (UTF-8, UTF-16BE UTF-16LE).
• BLOB. , , .

, , , sqlite mysql .

Answer 2

, , mySQL SQLite. Google, , , , (YMMV):

http://drupal.org/node/159605

Answer 3

;

SQLite 5- , , : , INTEGER ( 1 8 ), REAL (8- ), () BLOB ( / ).

"Affinity". "" 5 .

Sqlite . ; ; . ; . , TINYCHAR TEXT, TEXT.

, . "3,14" REAL TEXT

SqLite /.

"INT" (tinyint, smalint, integer "INT" ), INTEGER. ( "10" ), (10).

"INT", Sqlite "CHAR", "CLOB" "TEXT". , "". , .

Datatype "INT", "CHAR", "CLOB" "TEXT", Sqlite "BLOB". "BLOB", NONE ( ).

"REAL", "FLOA" "DOUB", REAL

- teste , NUMERIC ( ). , sqlite attemp tro convert. ou, , . ( .

, byt, . : TEXT = ISO8601 ( "-- : : SS.SSS" ). REAL = , 24 4714 . B.C. . INTEGER = Unix Time, 1970-01-01 00:00:00 UTC.