How do I insert a string with a linefeed into derby via an SQL script
with ij?
The string literal that java would insert would look like this:
"line1\nline2".
I need to insert it via an SQL script. I've tried using unicode \u000A
and \n and neither will work.
i.e. insert into test (id, test) values (1, 'line1\u000Aline2'); (or
line1\nline2 respectively)
When I select the contents, I get the line1\u000Aline2 or line1\nline2
back out and not the line feed I was expecting (ok, hoping) to see:
ie.
line1
line2
Is this possible?
--
Brian
