Sqlite3 メモ

公式サイト: http://www.sqlite.org/
使えるデータ型: http://www.sqlite.org/datatype3.html

公式サイトからの抜粋

  • NULL.
    • The value is a NULL value.
  • INTEGER.
    • The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value.
  • REAL.
    • The value is a floating point value, stored as an 8-byte IEEE floating point number.
  • TEXT.
    • The value is a text string, stored using the database encoding (UTF-8, UTF-16BE or UTF-16-LE).
  • BLOB.
    • The value is a blob of data, stored exactly as it was input.


datetime型が見つからないな