-
Notifications
You must be signed in to change notification settings - Fork 1
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 asINTEGER
. -
float
,double
anddecimal
are stored asREAL
. -
bool
s are stored asINTEGER
either as 1 or 0. -
byte[]
s are stored asBLOB
s. -
string
s are stored asTEXT
. -
TimeSpan
s are stored as ticks in anINTEGER
column. -
DateTime
s andDateTimeOffset
s are stored asTEXT
. The maximum accuracy supported by SQLite is milliseconds. -
Guid
is stored asTEXT
. -
char
is stored asTEXT
.
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.
- Getting Started
- Creating the Schema
- Updating data
- Querying data
- Data Types Support