ok, well, I thought I unicodeEscape was what I needed, but I tried:
java -cp derbyclient.jar;derbytools.jar -Dij.unicodeEscape=on
org.apache.derby.tools.ij
insert into test (id, test) values (1, 'line1\u000Aline2');
and I still got:
line1\u000Aline2 when I selected the rows for test.
Any ideas?
Brian
Brian Bonner wrote:
I think I found it:
*ij.unicodeEscape= { onoff }*
Brian
Brian Bonner wrote:
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?
