Small. Fast. Reliable.
Choose any three.
Choose any three.
Search results 31..40 of 47 for: character set
|
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 ...
... The leftmost column of the result set has the index 0.
The number of columns in the result can be determined using
sqlite3_column_count().
If the SQL statement does not currently point to a valid row, or if the
column index ...
|
|
What If OpenDocument Used SQLite?
(affcase1.html)
... The first line of the file is just:
<?xml version="1.0" encoding="UTF-8"?>
The second line of the file contains 211792 characters of
impenetrable XML. Yes, 211792 characters all on one line.
This file is a ...
|
|
The SQLite Bytecode Engine
(opcode.html)
4. The Opcodes
... set and either reg(P1) or
reg(P3) is NULL then the take the jump. If the SQLITE_JUMPIFNULL
bit is clear then fall through if either operand is NULL.
The SQLITE_AFF_MASK portion of P5 must be an affinity character -
SQLITE_AFF_TEXT ...
|
|
The Advantages Of Flexible Typing
(flextypegood.html)
3.5. Data typename cross-compatibility
Every SQL database engine seems to have its own unique set of supported
datatype names:
BIGINT
UNSIGNED SMALL INT
TEXT
VARCHAR
VARYING CHARACTER
NATIONAL VARYING CHARACTER
NVARCHAR
JSON
REAL
FLOAT
DOUBLE PRECISION
... and so forth ...
The fact that SQLite will ...
|
|
WAL-mode File Format
(walformat.html)
1.3. The Wal-Index or "-shm" file
... Because the shm is only used to coordinate access between concurrent
clients, the shm file is omitted if exclusive locking mode
is set, as an optimization. When exclusive locking mode is set,
SQLite uses heap memory in place of the ...
|
|
SQLite Older News
(oldnews.html)
... The fix is a 4-character
edit to a single line of code. Other than this 4-character change and
the update of the version number, nothing has changed from
version 3.7.15.1.
2012-12-19 - Release 3 ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
3.1. The eval method
... db1 eval {INSERT INTO t1 VALUES(1,'hello')}
db1 eval {INSERT INTO t1 VALUES(2,'goodbye')}
db1 eval {INSERT INTO t1 VALUES(3,'howdy!')}
set x [db1 eval {SELECT * FROM t1 ORDER BY a}]
The variable $x is ...
|
|
Pragma statements supported by SQLite
(pragma.html)
... When querying the value of a setting, many pragmas return the number
rather than the keyword.
A pragma may have an optional schema-name
before the pragma name.
The schema-name is the name of an ATTACH-ed database
or ...
|
|
Quality Management
(qmplan.html)
... The set of checklist items for release checklist is potentially
updated for each release. The content and complete
history of each release checklist are retained for the historical
record.
5. Software Configuration Management
5.1. Version Control
SQLite source code ...
|
|
The Virtual Table Mechanism Of SQLite
(vtab.html)
2.21. The xShadowName Method
... The xShadowName method returns true when its input is the part
of the table name past the last "_" character.
If SQLite recognizes a table as a shadow table, and if the
SQLITE_DBCONFIG_DEFENSIVE flag is set, then the shadow table ...
|
Page generated by FTS5 in about 57.91 ms.