Lines Matching refs:BLOB
636 ** [prepared statements], [sqlite3_blob_close | close] all [BLOB handles], and
640 ** statements, BLOB handlers, and/or unfinished sqlite3_backup objects then
643 ** statements, unclosed BLOB handlers, and/or unfinished sqlite3_backups,
647 ** connection after all prepared statements are finalized, all BLOB handles
773 #define SQLITE_TOOBIG 18 /* String or BLOB exceeds size limit */
4310 ** <dd>The maximum size of any string or BLOB or table row, in bytes.<dd>)^
4816 ** ^The fifth argument to the BLOB and string binding interfaces controls
4819 ** ^ (1) A destructor to dispose of the BLOB or string after SQLite has finished
4820 ** with it may be passed. ^It is called to dispose of the BLOB or string even
4841 ** ^The sqlite3_bind_zeroblob() routine binds a BLOB of length N that
4846 ** [sqlite3_blob_open | incremental BLOB I/O] routines.
4847 ** ^A negative value for the zeroblob results in a zero-length BLOB.
4870 ** ^[SQLITE_TOOBIG] might be returned if the size of a string or BLOB
5218 ** <li> BLOB
5247 ** <tr><td><b>sqlite3_column_blob</b><td>→<td>BLOB result
5256 ** <tr><td><b>sqlite3_column_bytes</b><td>→<td>Size of a BLOB
5307 ** If the result is a BLOB or a TEXT string, then the sqlite3_column_bytes()
5309 ** of that BLOB or string.
5311 ** ^If the result is a BLOB or UTF-8 string then the sqlite3_column_bytes()
5312 ** routine returns the number of bytes in that BLOB or string.
5320 ** ^If the result is a BLOB or UTF-16 string then the sqlite3_column_bytes16()
5321 ** routine returns the number of bytes in that BLOB or string.
5337 ** value from sqlite3_column_blob() for a zero-length BLOB is a NULL pointer.
5369 ** <tr><td> NULL <td> BLOB <td> Result is a NULL pointer
5372 ** <tr><td> INTEGER <td> BLOB <td> Same as INTEGER->TEXT
5375 ** <tr><td> FLOAT <td> BLOB <td> [CAST] to BLOB
5378 ** <tr><td> TEXT <td> BLOB <td> No change
5379 ** <tr><td> BLOB <td> INTEGER <td> [CAST] to INTEGER
5380 ** <tr><td> BLOB <td> FLOAT <td> [CAST] to REAL
5381 ** <tr><td> BLOB <td> TEXT <td> [CAST] to TEXT, ensure zero terminator
5392 ** <li> The initial content is a BLOB and sqlite3_column_text() or
5795 ** <tr><td><b>sqlite3_value_blob</b><td>→<td>BLOB value
5806 ** <tr><td><b>sqlite3_value_bytes</b><td>→<td>Size of a BLOB
6139 ** an application-defined function to be the BLOB whose content is pointed
6145 ** a BLOB containing all zero bytes and N bytes in size.
6175 ** error indicating that a string or BLOB is too long to represent.
6216 ** function as the destructor on the text or BLOB result when it has
6220 ** assumes that the text or BLOB result is in constant space and does not
7780 ** CAPI3REF: A Handle To An Open BLOB
7781 ** KEYWORDS: {BLOB handle} {BLOB handles}
7783 ** An instance of this object represents an open BLOB on which
7784 ** [sqlite3_blob_open | incremental BLOB I/O] can be performed.
7788 ** can be used to read or write small subsections of the BLOB.
7789 ** ^The [sqlite3_blob_bytes()] interface returns the size of the BLOB in bytes.
7794 ** CAPI3REF: Open A BLOB For Incremental I/O
7798 ** ^(This interfaces opens a [BLOB handle | handle] to the BLOB located
7800 ** in other words, the same BLOB that would be selected by:
7812 ** ^If the flags parameter is non-zero, then the BLOB is opened for read
7813 ** and write access. ^If the flags parameter is zero, the BLOB is opened for
7816 ** ^(On success, [SQLITE_OK] is returned and the new [BLOB handle] is stored
7830 ** a TEXT or BLOB value)^,
7842 ** A BLOB referenced by sqlite3_blob_open() may be read using the
7844 ** [sqlite3_blob_write()]. The [BLOB handle] can be moved to a
7846 ** interface. However, the column, table, or database of a [BLOB handle]
7847 ** cannot be changed after the [BLOB handle] is opened.
7849 ** ^(If the row that a BLOB handle points to is modified by an
7851 ** then the BLOB handle is marked as "expired".
7853 ** other than the one the BLOB handle is open on.)^
7855 ** an expired BLOB handle fail with a return code of [SQLITE_ABORT].
7856 ** ^(Changes written into a BLOB prior to the BLOB expiring are not
7857 ** rolled back by the expiration of the BLOB. Such changes will eventually
7869 ** To avoid a resource leak, every open [BLOB handle] should eventually
7887 ** CAPI3REF: Move a BLOB Handle to a New Row
7890 ** ^This function is used to move an existing [BLOB handle] so that it points
7894 ** remain the same. Moving an existing [BLOB handle] to a new row is
7912 ** CAPI3REF: Close A BLOB Handle
7915 ** ^This function closes an open [BLOB handle]. ^(The BLOB handle is closed
7935 ** CAPI3REF: Return The Size Of An Open BLOB
7938 ** ^Returns the size in bytes of the BLOB accessible via the
7939 ** successfully opened [BLOB handle] in its only argument. ^The
7943 ** This routine only works on a [BLOB handle] which has been created
7951 ** CAPI3REF: Read Data From A BLOB Incrementally
7954 ** ^(This function is used to read data from an open [BLOB handle] into a
7956 ** from the open BLOB, starting at offset iOffset.)^
7958 ** ^If offset iOffset is less than N bytes from the end of the BLOB,
7964 ** ^An attempt to read from an expired [BLOB handle] fails with an
7970 ** This routine only works on a [BLOB handle] which has been created
7980 ** CAPI3REF: Write Data Into A BLOB Incrementally
7983 ** ^(This function is used to write data into an open [BLOB handle] from a
7985 ** into the open BLOB, starting at offset iOffset.)^
7993 ** ^If the [BLOB handle] passed as the first argument was not opened for
7997 ** This function may only modify the contents of the BLOB; it is
7998 ** not possible to increase the size of a BLOB using this API.
7999 ** ^If offset iOffset is less than N bytes from the end of the BLOB,
8001 ** BLOB (and hence the maximum value of N+iOffset) can be determined
8005 ** ^An attempt to write to an expired [BLOB handle] fails with an
8006 ** error code of [SQLITE_ABORT]. ^Writes to the BLOB that occurred
8007 ** before the [BLOB handle] expired are not rolled back by the
8009 ** have been overwritten by the statement that expired the BLOB handle
8012 ** This routine only works on a [BLOB handle] which has been created
13306 ** The maximum length of a TEXT or BLOB in bytes. This also
15540 ** BTREE_BLOBKEY, the key is an arbitrary BLOB and no content is stored
17560 ** record BLOB generated by the OP_MakeRecord
17658 ** for a numeric type is a single comparison. And the BLOB type is first.
22382 "BLOB",
22624 char *z; /* String or BLOB value */
22697 #define MEM_Blob 0x0010 /* Value is a BLOB */
31440 case COLTYPE_BLOB: printf(" BLOB"); break;
34811 ** of a 1048569-byte BLOB or string.
34951 ** Convert a BLOB literal of the form "x'hhhhhh'" into its binary
80957 ** or a BLOB.
81354 case SQLITE_AFF_BLOB: { /* Really a cast to BLOB */
81427 ** Delete any previous value and set the value to be a BLOB of length
81549 ** Return true if the Mem object contains a TEXT or BLOB that is
81664 ** Change the value of a Mem to be a string or a BLOB.
84654 /* pSub is initiallly NULL. It is initialized to a BLOB by
86249 ** N>=12 and even (N-12)/2 BLOB
86549 /* EVIDENCE-OF: R-14606-31564 Value is a BLOB that is (N-12)/2 bytes in
88097 ** point number string BLOB NULL
88117 SQLITE_BLOB, /* 0x10 BLOB */
88121 SQLITE_INTEGER, /* 0x14 INTEGER + BLOB */
88125 SQLITE_FLOAT, /* 0x18 FLOAT + BLOB */
89379 ** Bind a text or BLOB value.
90713 ** pMem currently only holds a string type (or maybe a BLOB that we can
91029 /* SQLITE_BLOB */ "BLOB",
91624 ** the datatype of the register P2 is converted to BLOB. The content is
91625 ** the same sequence of bytes, it is merely interpreted as a BLOB instead
91628 ** if( P3!=0 and reg[P3]==P5 ) reg[P2] := CAST(reg[P2] as BLOB)
92361 ** <li> P2=='A' → BLOB
93623 ** If P4 is NULL then all index fields have the affinity BLOB.
93732 ** N>=12 and even BLOB
99270 ** This file contains code used to implement incremental BLOB I/O.
99301 ** contain a value of type TEXT or BLOB in the column nominated when the
114921 /* Initialize the BLOB value of a ROWID
115003 ** return value is BLOB, but it is really just a pointer to the StatAccum
115404 ** has type BLOB but it is really just a pointer to the StatAccum object.
119050 ** 'BLOB' with a default size of 4 bytes. */
119119 ** 'BLOB' | SQLITE_AFF_BLOB
119143 }else if( h==(('b'<<24)+('l'<<16)+('o'<<8)+'b') /* BLOB */
119172 /* BLOB(k), VARCHAR(k), CHAR(k) -> r=(k/4+1) */
119179 v = 16; /* BLOB, TEXT, CLOB -> r=5 (approx 20 bytes)*/
120131 ** a datatype that is one of INT, INTEGER, REAL, TEXT, or BLOB.
128662 ** 'A' BLOB
128759 ** 'A' BLOB
136075 ** NULL, TEXT, or BLOB.
136143 0x18, /* BLOB */
136159 ** NULL, TEXT, or BLOB. */
136161 sqlite3VdbeChangeP5(v, 0x1c); /* NULL, TEXT, or BLOB */
136170 sqlite3VdbeChangeP5(v, 0x1b); /* NULL, INT, FLOAT, or BLOB */
136177 sqlite3VdbeChangeP5(v, 0x1c); /* NULL, TEXT, or BLOB */
142927 int bHasAffBlob; /* At least one column in apExpr[] as affinity BLOB */
143066 ** + pExpr is a column with an affinity other than BLOB that matches
143140 ** columns with BLOB affinity is only allowed if the constant is used with
152676 ** with equality constraints that use BLOB or NONE affinity are set to
152683 ** the right hand side of the equality constraint (t2.b) has BLOB/NONE affinity,
152801 ** to a BLOB at appropriate times.
154864 ** that may only be NULL, a string, or a BLOB, never a number. (This means
167608 0, /* BLOB => nothing */
167881 /* 154 */ "BLOB",
168235 /* 182 */ "term ::= NULL|FLOAT|BLOB",
169146 216, /* (182) term ::= NULL|FLOAT|BLOB */
169556 -1, /* (182) term ::= NULL|FLOAT|BLOB */
170558 case 182: /* term ::= NULL|FLOAT|BLOB */
171707 #define CC_X 0 /* The letter 'x', or start of BLOB literal */
172697 /* If it is not a BLOB literal, then it must be an ID, since no
180314 "(id INTEGER PRIMARY KEY, value BLOB);",
180359 "CREATE TABLE %Q.'%q_segments'(blockid INTEGER PRIMARY KEY, block BLOB);",
180369 "root BLOB,"
180376 "CREATE TABLE %Q.'%q_docsize'(docid INTEGER PRIMARY KEY, size BLOB);",
191060 ** CREATE TABLE %_segments(blockid INTEGER PRIMARY KEY, block BLOB)
193244 char *zBuf, /* Write the BLOB here */
193260 const char *zBuf, /* The BLOB containing the varints */
193261 int nBuf /* size of the BLOB */
193285 char *pBlob; /* The BLOB encoding of the document size */
193286 int nBlob; /* Number of bytes in the BLOB */
193331 char *pBlob; /* Storage for BLOB written into %_stat */
193332 int nBlob; /* Size of BLOB written into %_stat */
193333 u32 *a; /* Array of integers that becomes the BLOB */
198264 ** a BLOB, but there is no support for JSONB in the current implementation.
198573 sqlite3_result_error(p->pCtx, "JSON cannot hold BLOB values", -1);
199690 ** is a BLOB, throw an error.
199974 ** is not a string or if any value is a BLOB, throw an error.
200971 ** CREATE TABLE %_node(nodeno INTEGER PRIMARY KEY, data BLOB)
201348 ** An instance of this structure (in the form of a BLOB) is returned by
202749 RtreeMatchArg *pBlob, *pSrc; /* BLOB returned by geometry function */
205705 ** If the input is a well-formed Geopoly BLOB or JSON string
205706 ** then return the BLOB representation of the polygon. Otherwise
205854 ** If the input is a well-formed Geopoly BLOB then return the area
207221 ** This routine frees the BLOB that is returned by geomCallback().
207240 ** as a BLOB.
207242 ** The R-Tree MATCH operator will read the returned BLOB, deserialize
208459 ** the existing value within the target database table must be of type BLOB.
215117 ** value must be a BLOB which is the correct page size, otherwise the
215165 "CREATE TABLE x(pgno INTEGER PRIMARY KEY, data BLOB, schema HIDDEN)");
215769 ** REBASE BLOB FORMAT:
230067 ** CREATE TABLE %_data(id INTEGER PRIMARY KEY, block BLOB);
235425 pConfig, "data", "id INTEGER PRIMARY KEY, block BLOB", 0, pzErr
240076 pConfig, "docsize", "id INTEGER PRIMARY KEY, sz BLOB", 0, pzErr
243187 ** of a 1048569-byte BLOB or string.