Data Types

Data type-hinting is the means by which SchemafreeSQL can determine the data types of your attributes at run-time.

Data type-hints are specified with the single character (the type) followed by a colon (e.g. 's:' which stands for 'string').

Within SFQL, a leading dollar sign '$' before the type-hint (e.g. 'SELECT $s:name...') differentiates a SchemafreeSQL attribute from other SQL grammar.


documentation in progress...
string
utf-8 string
type-hint: s
integer
64 bit integer
type-hint: i
float
64 bit floating-point number
type-hint: f
numeric
Decimal number up to 13 digits to the left and 5 digits to the right of the decimal.
type-hint: n
datetime
Date w/time. (see DateTime Expressions/Shortcuts)
type-hint: d
time
Time. (see DateTime Expressions/Shortcuts
type-hint: t
blob
binary large object
type-hint: b
object
object-type under which any of the above primitive attributes can reside.
type-hint: o