Datatypes In SQLite
(datatype3.html)
... Example Typenames From TheCREATE TABLE Statement
or CAST Expression
Resulting Affinity
Rule Used To Determine Affinity
INT
INTEGER
TINYINT
SMALLINT
MEDIUMINT
BIGINT
UNSIGNED BIG INT
INT2
INT8
INTEGER
1
CHARACTER(20)
VARCHAR(255)
VARYING CHARACTER(255)
NCHAR(55)
NATIVE CHARACTER ...
|
The SQLite Query Optimizer Overview
(optoverview.html)
5. The LIKE Optimization
... If the ESCAPE option is used, the ESCAPE character must be ASCII,
or a single-byte character in UTF-8.
The LIKE operator has two modes that can be set by a
pragma. The
default mode is for LIKE comparisons ...
|
JSON Functions And Operators
(json1.html)
... Within JSON value arguments interpreted as JSON strings, Unicode escape
sequences are not treated as equivalent to the characters or escaped
control characters represented by the expressed Unicode code point.
Such escape sequences are not translated or specially treated; they ...
|
The WITH Clause
(lang_with.html)
... An entry in x(s,ind) means that the 81-character string "s" is a valid
sudoku puzzle (it has no conflicts) and that the first unknown character
is at position "ind", or ind==0 if all character positions are ...
|
Temporary Files Used By SQLite
(tempfiles.html)
2.3. Shared-Memory Files
... The shared-memory file, if it exists, is located
in the same directory as the database file and has the same name as the
database file except with the 4 characters "-shm" appended.
Shared memory files only exist while running ...
|
C API: Create Or Redefine SQL Functions
(c3ref/create_function.html)
sqlite3_create_function(), sqlite3_create_function16(), sqlite3_create_function_v2(), sqlite3_create_window_function()
... Note that the name
length limit is in UTF-8 bytes, not characters nor UTF-16 bytes.
Any attempt to create a function with a longer name
will result in SQLITE_MISUSE being returned.
The third parameter (nArg)
is the number ...
|
The SQLite Zipfile Module
(zipfile.html)
3.2.1. Adding Entries to a Zip Archive
... Otherwise, if it is set to 0, then the file data or symbolic link
target is stored as is in the zip archive and the compression method
set to 0. If it is set to 8, then the file data ...
|
Swarmvtab Virtual Table
(swarmvtab.html)
... 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 ...
|
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 ...
|
Page generated by FTS5 in about 51.62 ms.