Sqlite

sqlite has some idiosyncracies.

newlines in text

newlines can’t be escaped (\n), so you need to have the bytes in question be the value of ␊, (0x0A, or 10).

there are 3 ways to do it:

text with the raw character value in the string.

'this is

a broken line'

or the two other ways using || (concat).

'this is' || char(10) || 'a broken line'

'this is' || x'0A' || 'a broken line'

the first one uses the char() function.

the second one uses some kind of ‘blob’ notation (???).

strings and quotes

strings are surrounded by single-quotes (').

double-quotes don’t work.

if you need single-quotes in your string, just escape them by doubling up:

'this string''s single quotes are few'