Skip to content

Data Types Support

Dominic Fischer edited this page Jul 21, 2017 · 1 revision

The following Data Types are supported as Properties/Columns.

  • byte, sbyte, ushort, short, int, uint, long, ulong are stored as INTEGER.
  • float, double and decimal are stored as REAL.
  • bools are stored as INTEGER either as 1 or 0.
  • byte[]s are stored as BLOBs.
  • strings are stored as TEXT.
  • TimeSpans are stored as ticks in an INTEGER column.
  • DateTimes and DateTimeOffsets are stored as TEXT. The maximum accuracy supported by SQLite is milliseconds.
  • Guid is stored as TEXT.
  • char is stored as TEXT.

Nullable types of the structs are also supported.

If you wish to stored custom data types or supported types differently, use another property as a wrapper.

Clone this wiki locally