Hard return in the insert statement

[gandolf989]

Originally posted by Blu
How can I insert the data that contain the line breaks or hard return ?

You can concatenate a CHR(10).

INSERT INTO blah ('blah blah blah blah blah blah ' || CHR(10) ||
                  'blah blah blah blah blah blah ' );