Small. Fast. Reliable.
Choose any three.
Choose any three.
|
NUL Characters In Strings
(nulinstr.html)
4. Removing NUL Characters From A Text Field
The following example shows how to remove NUL character, and all text
that follows, from a column of a table. So if you have a database file
that contains embedded NULs and you would like to remove them, running
UPDATE ...
|
|
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 ...
... For UTF16 input text to the sqlite3_result_text16(),
sqlite3_result_text16be(), sqlite3_result_text16le(), and
sqlite3_result_text64() routines, if the text contains invalid
UTF16 characters, the invalid characters might be converted
into the unicode replacement character, U+FFFD.
The sqlite3_result_value() interface sets the result of
the ...
|
|
C API: String LIKE Matching
(c3ref/strlike.html)
sqlite3_strlike()
... For "X LIKE P" without
the ESCAPE clause, set the E parameter of sqlite3_strlike(P,X,E) to 0.
As with the LIKE operator, the sqlite3_strlike(P,X,E) function is case
insensitive - equivalent upper and lower case ASCII characters ...
|
|
Uniform Resource Identifiers
(uri.html)
... Convert all "?" characters into "%3f".
Convert all "#" characters into "%23".
On windows only, convert all "\" characters into "/".
Convert all sequences of two or more "/" characters into a
single "/" character.
On windows only, if the filename begins with a drive letter ...
|
|
SQLite FTS5 Extension
(fts5.html)
4.3.1. Unicode61 Tokenizer
... All characters in the
string that this option is set to are considered token characters.
separators
This option is used to specify additional unicode characters that
should be considered as separator characters, even if they are token
characters according to ...
|
|
SQLite's Built-in printf()
(printf.html)
2.5. The Options Flags Field
... A "-" sign always appears before negative numbers regardless of flag settings.
(space)
For signed numeric substitutions, prepend a single space before positive
numbers.
0
(The zero-padding option)
Prepend as many "0" characters to numeric substitutions as necessary to
expand ...
|
|
C API: Binding Values To Prepared Statements
(c3ref/bind_blob.html)
sqlite3_bind_blob(), sqlite3_bind_blob64(), sqlite3_bind_double(), sqlite3_bind_int(), sqlite3_bind_int64(), sqlite3_bind_null ...
... If UTF16 input text contains invalid unicode
characters, then SQLite might change those invalid characters
into the unicode replacement character: U+FFFD.
In those routines that have a fourth argument, its value is the
number of bytes in the parameter ...
|
|
C API: Opening A New Database Connection
(c3ref/open.html)
sqlite3_open(), sqlite3_open16()
... Filenames containing international
characters must be converted to UTF-8 prior to passing them into
sqlite3_open() or sqlite3_open_v2().
Note to Windows Runtime users: The temporary directory must be set
prior to calling sqlite3_open() or sqlite3_open_v2(). Otherwise, various
features that require ...
|
|
SQL Language Expressions
(lang_expr.html)
... The "E" character that begins the exponentiation
clause of a floating point literal can be either upper or lower case.
The "." character is always used
as the decimal point even if the locale setting specifies "," for
this role - the use ...
|
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
8. Tokenizers
... If this option is set to "2", then diacritics are correctly
removed from all Latin characters.
It is also possible to customize the set of codepoints that unicode61 treats
as separator characters. The "separators=" option may be used to specify ...
|
Page generated by FTS5 in about 52.83 ms.