Simmi,
This does not work for derby. char returns the character string
representation. for 10, it returns '6 '. I'm aware of other DB's
using chr(10).
Brian
simmi iyer wrote:
This method works for many other databases. Not sure
about Derby but try it out.
insert into table1 (id,test)
values(1,'try'||char(10)||'try')
--- Brian Bonner <[EMAIL PROTECTED]> wrote:
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?
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
