SQLite QUOTE() Function

The SQLite QUOTE() function returns the text of an SQL literal which is the value of its argument suitable for inclusion into an SQL statement. Strings are surrounded by single-quotes with escapes on interior quotes as needed. BLOBs are encoded as hexadecimal literals. Strings with embedded NUL characters cannot be represented as string literals in SQL and hence the returned string literal is truncated prior to the first NUL.

Syntax

QUOTE(X)

Parameters

Return Value

Returns a string suitable for inclusion into an SQL statement.

Example 1:

The example below shows the usage of QUOTE() function.

SELECT QUOTE('Don''t!');
Result: 'Don''t!'

SELECT QUOTE('Don''t! Do it');
Result: 'Don''t! Do it'