SQLite Databases are created and maintained by Smart Devices Applications generated by GeneXus' Native Mobile Generator.
Generated Schema depends on Connectivity Support property.
Offline Native Mobile applications generate a normalized database, while the online ones generate just a very simple one to use the SQLite database as a cache. Take a look at Online Native Mobile applications architecture and Offline Native Mobile applications architecture for a deeper understanding.
Data is stored in unicode (specifically UTF8 ).
| GeneXus Datatype |
|
SQLite Datatype |
| |
| N(X) |
X<19 |
INTEGER |
| N(X) |
X>=19 |
NUMERIC |
| N(X,Y) |
|
NUMERIC |
| CHAR |
|
TEXT |
| VARCHAR |
|
TEXT |
| LONGVARCHAR |
|
TEXT |
| BLOB |
|
TEXT |
| DATE |
|
TEXT |
| DATETIME |
|
TEXT |
| BOOLEAN |
|
INTEGER |
| |
|
|
https://www.sqlite.org/limits.html
Limits may vary depending on the Device's limits and the SQLite version installed in those devices.