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 <brian.bonner@paraware.com> 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
|