Command Line Shell For SQLite
(cli.html)
16. SQL Parameters
... set
using the sqlite3_bind_...() family of APIs.
Parameters can be either named or unnamed. An unnamed parameter is a single
question mark ("?"). Named parameters are a "?" followed immediately by a number
(ex: "?15" or "?123") or one of the characters ...
|
The RBU Extension
(rbu.html)
2.2.2. RBU Database Contents
... For
each column that is being updated, the corresponding character is set to
'x'. For those that remain as they are, the corresponding character of the
rbu_control value should be set to '.'. For example, given the tables
above, the update ...
|
The Spellfix1 Virtual Table
(spellfix1.html)
9. The editdist3 COST table
... To disable the default insertion, deletion, and/or substitution
set their respective cost to 10000 or more.
Other entries in the cost table specific transforms for particular
characters.
The cost of specific transforms should be less than the default costs ...
|
C API: Extract Metadata About A Column Of A Table
(c3ref/table_column_metadata.html)
sqlite3_table_column_metadata()
... The memory pointed to by the character pointers returned for the
declaration type and collation sequence is valid until the next
call to any SQLite API function.
If the specified table is actually a view, an error code is returned ...
|
Quirks, Caveats, and Gotchas In SQLite
(quirks.html)
... NUL Characters Are Allowed In Text Strings
NUL characters (ASCII code 0x00 and Unicode \u0000) may appear in
the middle of strings in SQLite. This can lead to unexpected behavior.
See the "NUL characters in strings" document for further information ...
|
C API: OS Interface Object
(c3ref/vfs.html)
sqlite3_syscall_ptr(), struct sqlite3_vfs
... If a suffix is added to the zFilename parameter, it will
consist of a single "-" character followed by no more than
11 alphanumeric and/or "-" characters.
SQLite further guarantees that
the string will be valid and unchanged until xClose() is ...
|
The C language interface to SQLite Version 2
(c_interface.html)
... then the library assumes UTF-8 variable
sized characters. This makes a difference for the LIKE and GLOB
operators and the LENGTH() and SUBSTR() functions. The static
string sqlite_encoding will be set to either "UTF-8" or
"iso8859" to indicate ...
|
SQLite Frequently Asked Questions
(faq.html)
... You can declare
a VARCHAR(10) and SQLite will be happy to store a 500-million character
string there. And it will keep all 500-million characters intact.
Your content is never truncated. SQLite understands the column type
of "VARCHAR ...
|
Run-Time Loadable Extensions
(loadext.html)
2. Loading An Extension
... If that does not work, it constructs a
entry point using the template "sqlite3_X_init" where the X is replaced
by the lowercase equivalent of every ASCII character in the filename
after the last "/" and before the first following "." omitting the ...
|
Implementation Limits For SQLite
(limits.html)
... do useful work,
and so for that reason we have set this parameter relatively low.
The number of arguments to a function is sometimes stored in a signed
character. So there is a hard upper bound on SQLITE_MAX_FUNCTION_ARG
of 127 ...
|
Page generated by FTS5 in about 54.65 ms.