sqlite3_mprintf

Navigation

API > API/Plugins > API/Plugins/SQLiteCore > API/Plugins/SQLiteCore/sqlite

References

char * sqlite3_mprintf  
(  
    const char *,  
    ...  
)  
Copy full snippet

char * sqlite3_mprintf (     const char *,     ... )

Remarks

CAPI3REF: Formatted String Printing Functions

These routines are work-alikes of the "printf()" family of functions from the standard C library. These routines understand most of the common formatting options from the standard library printf() plus some additional non-standard formats ([q], [Q], [w], and [z]). See the [built-in printf()] documentation for details.

^The sqlite3_mprintf() and sqlite3_vmprintf() routines write their results into memory obtained from [sqlite3_malloc64()]. The strings returned by these two routines should be released by [sqlite3_free()]. ^Both routines return a NULL pointer if [sqlite3_malloc64()] is unable to allocate enough memory to hold the resulting string.

^(The sqlite3_snprintf() routine is similar to "snprintf()" from the standard C library. The result is written into the buffer supplied as the second parameter whose size is given by the first parameter. Note that the order of the first two parameters is reversed from snprintf().)^ This is an historical accident that cannot be fixed without breaking backwards compatibility. ^(Note also that sqlite3_snprintf() returns a pointer to its buffer instead of the number of characters actually written into the buffer.)^ We admit that the number of characters written would be a more useful return value but we cannot change the implementation of sqlite3_snprintf() now without breaking compatibility.

^As long as the buffer size is greater than zero, sqlite3_snprintf() guarantees that the buffer is always zero-terminated. ^The first parameter "n" is the total size of the buffer, including space for the zero terminator. So the longest string that can be completely written will be n-1 characters.

^The sqlite3_vsnprintf() routine is a varargs version of sqlite3_snprintf().

See also: [built-in printf()], [printf() SQL function]