Thomas that works, although I was hoping for something that was less
sensitive to whitespace (specifically carriage returns).
Brian
Thomas J. Taylor wrote:
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:[EMAIL PROTECTED]
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?
