Small. Fast. Reliable.
Choose any three.

Search results 1..10 of 45 for: character set

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

12345

Page generated by FTS5 in about 54.69 ms.