Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQL Language Expressions
(lang_expr.html)
... A string constant is formed by enclosing the
string in single quotes ('). A single quote within the string can
be encoded by putting two single quotes in a row - as in Pascal.
C-style escapes using the backslash character are ...
|
|
SQLite FTS5 Extension
(fts5.html)
3.1. FTS5 Strings
... By enclosing it in double quotes ("). Within a string, any embedded
double quote characters may be escaped SQL-style - by adding a second
double-quote character.
As an FTS5 bareword that is not "AND", "OR" or "NOT" (case sensitive).
An ...
|
|
Swarmvtab Virtual Table
(swarmvtab.html)
3. Advanced Usage
... An optional parameter
is specified using its name, followed by an "=" character, followed by an
optionally quoted value. Whitespace may separate the name, "=" character
and value. For example:
CREATE VIRTUAL TABLE temp.sv USING swarmvtab (
'SELECT ...', -- the SELECT statement
maxopen ...
|
|
Floating Point Numbers
(floatingpoint.html)
2.1.3. The ieee754_from_blob() and ieee754_to_blob() functions
... sqlite> .mode box
sqlite> SELECT quote(ieee754_to_blob(4.94065645841247e-324)) AS binary64;
┌─────────────────────┐
│ binary64 │
├─────────────────────┤
│ X'0000000000000001' │
└─────────────────────┘
|
|
Compile-time Options
(compile.html)
4. Options To Set Default Parameter Values
... SQLITE_DQS=N
This macro determines the default values for
SQLITE_DBCONFIG_DQS_DDL and SQLITE_DBCONFIG_DQS_DML, which
in turn determine how SQLite handles each double-quoted string literal.
The "DQS" name stands for
"Double-Quoted String".
The N argument should be an integer 0 ...
|
|
Implementation Limits For SQLite
(limits.html)
... The use of binding
obviates the need to escape quote characters in the string, reducing the
risk of SQL injection attacks. It also runs faster since the large
string does not need to be parsed or copied as much.
The ...
|
|
Pragma statements supported by SQLite
(pragma.html)
PRAGMA temp_store_directory
... The value directory-name should be enclosed in single quotes.
To revert the directory to the default, set the directory-name to
an empty string, e.g., PRAGMA temp_store_directory = ''. An
error is raised if directory-name is not found or ...
|
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
6. FTS4 Options
... The option value may optionally be enclosed in single or double quotes, with
embedded quote characters escaped in the same way as for SQL literals. There
may not be whitespace on either side of the "=" character. For example,
to create ...
|
Page generated by FTS5 in about 28.60 ms.