From derby-user-return-1847-apmail-db-derby-user-archive=db.apache.org@db.apache.org Tue Aug 30 03:23:17 2005 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 85379 invoked from network); 30 Aug 2005 03:23:17 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 30 Aug 2005 03:23:17 -0000 Received: (qmail 8439 invoked by uid 500); 30 Aug 2005 03:23:16 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 8121 invoked by uid 500); 30 Aug 2005 03:23:15 -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 8108 invoked by uid 99); 30 Aug 2005 03:23:15 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 29 Aug 2005 20:23:15 -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; Mon, 29 Aug 2005 20:23:30 -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-1E9wiN2TBJ-0007Z3; Mon, 29 Aug 2005 23:23:11 -0400 Message-ID: <4313D116.4050402@paraware.com> Date: Mon, 29 Aug 2005 23:23:02 -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: <4313825E.5080008@paraware.com> <4313BE4E.7020503@paraware.com> In-Reply-To: <4313BE4E.7020503@paraware.com> 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 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? >> >