db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brian Bonner <brian.bon...@paraware.com>
Subject Re: Inserting a new line (\n) via sql script into Derby
Date Tue, 30 Aug 2005 02:02:54 GMT
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?
>


Mime
View raw message