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: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?
>>
>>
>>
>
>
>
>
>
|