Re: [sqlite] Line feeds

[Nemanja Corlija]

On 5/23/06, Andrew Ward <[EMAIL PROTECTED]> wrote:

Hi,
How can I perform an insert that contains linefeeds, such as

INSERT INTO X VALUES (123, 'a'||chr(10)||'b');

You can insert it as a hex string:

INSERT INTO t VALUES (123, 'a' || x'0A' || 'b');

--
Nemanja Corlija <[EMAIL PROTECTED]>