db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From simmi iyer <simmi_i...@yahoo.com>
Subject Re: Inserting a new line (\n) via sql script into Derby
Date Tue, 30 Aug 2005 05:14:47 GMT
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 

Mime
View raw message