Small. Fast. Reliable.
Choose any three.
Choose any three.
|
C API: Virtual Table Constraint Operator Codes
(c3ref/c_index_constraint_eq.html)
SQLITE_INDEX_CONSTRAINT_EQ, SQLITE_INDEX_CONSTRAINT_GT, SQLITE_INDEX_CONSTRAINT_LE, SQLITE_INDEX_CONSTRAINT_LT, SQLITE_INDEX_CONSTRAINT_GE, SQLITE_INDEX_CONSTRAINT_MATCH ...
... The collating sequence to be used for comparison can be found using
the sqlite3_vtab_collation() interface. For most real-world virtual
tables, the collating sequence of constraints does not matter (for example
because the constraints are numeric) and so the sqlite3_vtab_collation ...
|
|
C/C++ Interface For SQLite Version 3 (old)
(capi3.html)
... Separate comparison functions can exist for the same collating
sequence for each of the UTF-8, UTF-16LE and UTF-16BE text representations.
The sqlite3_create_collation16() works like sqlite3_create_collation() except
that the collation name is specified in UTF-16 host byte ...
|
|
Generated Columns
(gencol.html)
2.3. Limitations
... The datatype and collating sequence of the generated column are determined
only by the datatype and COLLATE clause on the column definition.
The datatype and collating sequence of the GENERATED ALWAYS AS expression
have no affect on the datatype and ...
|
|
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 ...
|
|
C API: Error Logging Interface
(c3ref/log.html)
sqlite3_log()
... The sqlite3_log() interface is intended for use by extensions such as
virtual tables, collating functions, and SQL functions. While there is
nothing to prevent an application from calling sqlite3_log(), doing so
is considered bad form.
The zFormat string must not ...
|
|
SELECT
(lang_select.html)
... The collation sequence used to compare
two text values is determined as follows:
If the ORDER BY expression is assigned a collation sequence using
the postfix COLLATE operator, then the specified collation sequence is
used.
Otherwise, if the ORDER BY ...
|
|
CREATE TABLE
(lang_createtable.html)
... The COLLATE clause
The COLLATE clause specifies the name of a collating sequence to use as
the default collation sequence for the column. If no COLLATE clause is
specified, the default collation sequence is BINARY.
3.4. The GENERATED ALWAYS ...
|
|
SQL Language Expressions
(lang_expr.html)
... The COLLATE operator is a unary postfix
operator that assigns a collating sequence to an expression.
The collating sequence set by the COLLATE operator overrides the
collating sequence determined by the COLLATE clause in a table
column definition.
See the ...
|
|
SQLite Keywords
(lang_keywords.html)
The SQL standard specifies a large number of keywords which may not
be used as the names of tables, indices, columns, databases, user-defined
functions, collations, virtual table modules, or any other named object.
The list of keywords is so ...
|
|
The COMPLETION() Table-Valued Function
(completion.html)
2. Details
... SELECT DISTINCT candidate COLLATE nocase
FROM completion($prefix, $wholeline)
ORDER BY 1;
The query above will return suggestions for the whole input word that
begins with $prefix. The $wholeline parameter is all text from the beginning
of the line up ...
|
Page generated by FTS5 in about 60.45 ms.