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 18:34:46 GMT
Simmi,

This does not work for derby.  char returns the character string 
representation.  for 10, it returns '6     '.  I'm aware of other DB's 
using chr(10).

Brian



simmi iyer wrote:

>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