What's wrong with just using the <ENTER> key?
- Thomas
ij> create table test (value varchar(60));
0 rows inserted/updated/deleted
ij> insert into test values ('First Line
Second Line');
1 row inserted/updated/deleted
ij> select * from test;
VALUE
------------------------------------------------------------
First Line
Second Line
-----Original Message-----
From: Brian Bonner [mailto:brian.bonner@paraware.com]
Sent: Monday, August 29, 2005 10:03 PM
To: Derby Discussion
Subject: Re: Inserting a new line (\n) via sql script into Derby
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?
>
|