Search notes:
SQLite function: quote
quote(val) returns a string that, as expression, evaluates to the same value as was quoted.
For example,
blobs are returned as «blob literals» (
x'…').
create table tq84_quote(t);
insert into tq84_quote values ( 'foo\bar' );
insert into tq84_quote values ( "foo\nar" );
insert into tq84_quote values ( 'Bill O''Dill');
insert into tq84_quote values (x'deadbeef' );
.mode column
.width 15 15
select t, quote(t) from tq84_quote;
--
-- foo\bar 'foo\bar'
-- foo\nar 'foo\nar'
-- Bill O'Dill 'Bill O''Dill'
-- �� X'DEADBEEF'
drop table tq84_quote;