最終更新:2014-01-19 (日) 00:46:08 (2392d)  

SQLite 3
Top / SQLite 3

データ型

データ型 (ストレージクラス) 

  • 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-16LE).
  • BLOB?. The value is a blob of data, stored exactly as it was input.

データ型変換 (Type Affinity)

関連

  • SQLite 2?

参考