Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite Version 3 Overview
(version3.html)
... Each database file manages text as either UTF-8, UTF-16BE (big-endian),
or UTF-16LE (little-endian). Internally and in the disk file, the
same text representation is used everywhere. If the text representation
specified by the database file ...
|
|
C API: Result Values From A Query
(c3ref/column_blob.html)
sqlite3_column_blob(), sqlite3_column_double(), sqlite3_column_int(), sqlite3_column_int64(), sqlite3_column_text(), sqlite3_column_text16 ...
... Strings returned by sqlite3_column_text16() always have the endianness
which is native to the platform, regardless of the text encoding set
for the database.
Warning: The object returned by sqlite3_column_value() is an
unprotected sqlite3_value object. In a multithreaded environment,
an unprotected ...
|
|
SQLite As An Application File Format
(appfileformat.html)
... SQLite database files are portable between 32-bit and 64-bit machines and
between big-endian and little-endian architectures and between any of the
various flavors of Windows and Unix-like operating systems.
The application using an SQLite application ...
|
|
Floating Point Numbers
(floatingpoint.html)
2.1.3. The ieee754_from_blob() and ieee754_to_blob() functions
The ieee754_to_blob(F) SQL function converts the floating point number F
into an 8-byte BLOB that is the big-endian binary64 encoding of that number.
The ieee754_from_blob(B) function goes the other way, converting an 8-byte
blob into ...
|
|
TH3
(th3.html)
3. Generating A Test Program
... 64-bit little-endian
th3: SQLite 3.8.11 2015-05-15 04:13:15 56ef98a04765c34c1c2f3ed7a6f03a732f3b886e
The output begins with a report of the SQLITE_SOURCE_ID
(cross-checked again sqlite3_sourceid()) for the
SQLite under test and the compile-time options used ...
|
|
Pragma statements supported by SQLite
(pragma.html)
PRAGMA encoding
... the text encoding used by the
main database, one of 'UTF-8', 'UTF-16le' (little-endian UTF-16
encoding) or 'UTF-16be' (big-endian UTF-16 encoding). If the main
database has not already been created, then the value returned ...
|
|
How SQLite Is Tested
(testing.html)
8.6. Undefined Behavior Checks
... Tests are then repeated
on 32-bit and 64-bit systems and on big-endian and little-endian systems,
using a variety of CPU architectures.
Furthermore, the test suites are augmented with many test cases that are
deliberately designed to ...
|
|
Compile-time Options
(compile.html)
3. Platform Configuration
... SQLITE_BYTEORDER=(0|1234|4321)
SQLite needs to know if the native byte order of the target CPU is
big-endian or little-ending. The SQLITE_BYTEORDER preprocessor is set
to 4321 for big-endian machines and 1234 for little-endian machines ...
|
|
WAL-mode File Format
(walformat.html)
2.1. The WAL-Index Header
... 0 if the WAL
uses little-endian checksums.
14..15szPage
The database page size in bytes, or 1 if the page size is 65536.
16..19mxFrame
Number of valid and committed frames in the WAL file.
20..23nPage
Size of ...
|
|
SQLite FTS5 Extension
(fts5.html)
9.1. Varint Format
... Varints are
big-endian: bits taken from the earlier byte of the varint are more significant
than bits taken from the later bytes.
|
Page generated by FTS5 in about 34.52 ms.