SmartStore Data Types
Like any database, SmartStore defines a set of data
types that you use to create soups. SmartStore data types mirror the
underlying SQLite database.
SmartStore supports the
following data types for declaring index specs. In a SmartStore soup definition, an
index spec defines the data type that SmartStore expects to find in the
given field.
| Type | Description |
|---|---|
| integer | Signed integer, stored in 4 bytes (SDK 2.1 and earlier) or 8 bytes (SDK 2.2 and later) |
| floating | Floating point value, stored as an 8-byte IEEE floating point number |
| string | Text string, stored with database encoding (UTF-8) |
| full_text | String that supports full-text searching |
| JSON1 | Index type based on the SQLite JSON1 extension. Can be used in place of integer, floating, and string types. Behaves identically to those types of index specs, except that JSON1 does not support index paths that traverse arrays. |