SQLite: Single File Database
(onefile.html)
... SQLite databases
are portable across 32-bit and 64-bit machines
and between
big-endian and
little-endian
architectures.
The SQLite database file format is also stable.
All releases of SQLite version 3 can read and write database
files created ...
|
The Base85() SQL Function
(base85.html)
2. Encoding
... Groups of 1-3 bytes are represented with 2-4 digits,
still big-endian but 8-24 bit values. (Using big-endian yields
the simplest transition to byte groups smaller than 4 bytes.
These byte groups can also be considered ...
|
Database File Format
(fileformat.html)
1.3.2. Page Size
... This value can be interpreted as a big-endian
1 and thought of as a magic number to represent the 65536 page size.
Or one can view the two-byte field as a little endian number and say
that it ...
|
Long Term Support
(lts.html)
... Stable, Cross-platform Database Files →
SQLite database files are bit-for-bit identical on
32-bit, 64-bit, big-endian, and little-endian platforms. You
can copy an SQLite database file from one system to another
without having to ...
|
About SQLite
(about.html)
... The database file format is cross-platform - you can freely copy a database
between 32-bit and 64-bit systems or between
big-endian and
little-endian
architectures. These features make SQLite a popular choice as
an Application File Format ...
|
C API: Obtaining SQL Values
(c3ref/value_blob.html)
sqlite3_value_blob(), sqlite3_value_double(), sqlite3_value_int(), sqlite3_value_int64(), sqlite3_value_pointer(), sqlite3_value_text ...
... The
sqlite3_value_text16be() and sqlite3_value_text16le() interfaces
extract UTF-16 strings as big-endian and little-endian respectively.
If sqlite3_value object V was initialized
using sqlite3_bind_pointer(S,I,P,X,D) or sqlite3_result_pointer(C,P,X,D)
and if X and Y ...
|
C API: Setting The Result Of An SQL Function
(c3ref/result_blob.html)
sqlite3_result_blob(), sqlite3_result_blob64(), sqlite3_result_double(), sqlite3_result_error(), sqlite3_result_error16(), sqlite3_result_error_toobig ...
... The sqlite3_result_text(), sqlite3_result_text16(),
sqlite3_result_text16le(), and sqlite3_result_text16be() interfaces
set the return value of the application-defined function to be
a text string which is represented as UTF-8, UTF-16 native byte order,
UTF-16 little endian, or UTF-16 big ...
|
The Geopoly Interface To The SQLite R*Tree Module
(geopoly.html)
4.1. Binary Encoding of Polygons
... The least significant bit
of the flag byte determines whether the coordinate pairs that follow the
header are stored big-endian or little-endian. A value of 0 for the least
significant bit means big-endian and a value of ...
|
Benefits of SQLite As A File Format
(aff_short.html)
... Portability
The application file is portable across all operating systems,
32-bit and 64-bit and big- and little-endian architectures.
A federation of programs, perhaps all written in different programming
languages, can access the same application file with no ...
|
Distinctive Features Of SQLite
(different.html)
... Big-endian or little-endian, 32-bit or
64-bit does not matter. All machines use the same file format.
Furthermore, the developers have pledged to keep the file format
stable and backwards compatible, so newer versions of SQLite can ...
|
Page generated by FTS5 in about 33.74 ms.