Small. Fast. Reliable.
Choose any three.

Search results 21..30 of 45 for: character set

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 ... 
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 ... 
 ... 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 ... 
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 ... 
 ... 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 ... 

12345

Page generated by FTS5 in about 51.62 ms.