From derby-user-return-1856-apmail-db-derby-user-archive=db.apache.org@db.apache.org Tue Aug 30 18:31:24 2005 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 9585 invoked from network); 30 Aug 2005 18:31:23 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 30 Aug 2005 18:31:23 -0000 Received: (qmail 95908 invoked by uid 500); 30 Aug 2005 18:31:22 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 95876 invoked by uid 500); 30 Aug 2005 18:31:21 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 95860 invoked by uid 99); 30 Aug 2005 18:31:21 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 30 Aug 2005 11:31:21 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [217.160.230.40] (HELO mout.perfora.net) (217.160.230.40) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 30 Aug 2005 11:31:36 -0700 Received: from rrcs-24-123-4-130.central.biz.rr.com [24.123.4.130] (helo=[127.0.0.1]) by mrelay.perfora.net with ESMTP (Nemesis), id 0MKoyl-1EAAtB2OYo-0004Oq; Tue, 30 Aug 2005 14:31:17 -0400 Message-ID: <4314A5EB.2040104@paraware.com> Date: Tue, 30 Aug 2005 14:31:07 -0400 From: Brian Bonner User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Derby Discussion Subject: Re: Inserting a new line (\n) via sql script into Derby References: <0IM100597HOGI8@diamond.itqa.miami.edu> In-Reply-To: <0IM100597HOGI8@diamond.itqa.miami.edu> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: perfora.net abuse@perfora.net login:209aae35eb39d931bdced0e6de5151d6 X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N 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 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? >> >> >> > > > > >