Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 31474 invoked from network); 23 Feb 2009 10:40:43 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 23 Feb 2009 10:40:43 -0000 Received: (qmail 1204 invoked by uid 500); 23 Feb 2009 10:40:41 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 1189 invoked by uid 500); 23 Feb 2009 10:40:41 -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 1180 invoked by uid 99); 23 Feb 2009 10:40:41 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 23 Feb 2009 02:40:41 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of george.dma@gmail.com designates 74.125.78.25 as permitted sender) Received: from [74.125.78.25] (HELO ey-out-2122.google.com) (74.125.78.25) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 23 Feb 2009 10:40:34 +0000 Received: by ey-out-2122.google.com with SMTP id 25so362702eya.13 for ; Mon, 23 Feb 2009 02:40:13 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:message-id:subject :from:to:content-type:content-transfer-encoding; bh=uIS4kMY6asRAgnsmwrY0iPxqm1Vk+GrvRRj0rOCPqIo=; b=F5LAaZ5hw8FxcZ/pgoz9GDsZtq7wn/hGBXsFCOjb6n1uVWwK+qynglv7J0E5hDx+is HVYKnoOw7xp9Gm0tWZnffTERO6H2waXeKzaAytk3moXzpZuo70xxVisLlmj9ruXoanPa mIF/McJ7o0/o1K5UPw/9GNDdcHsItDdIVyS3A= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type :content-transfer-encoding; b=vk8cw4bkCvX0RDsBiV/3LI4ANxmzo9XIdQtfDfnYq+bXZwM4u3CVXixBCOSjWTCmb2 0Qe3Lqxp19ZQOokv8qA3jfrgEQVU5CZcqdLpi+BdUuf0sFTg8CSgo2LXzYvzn8pttlRI L6MgS9Tdaknfr95uPCxPtqt3DGCBgCAH67NCA= MIME-Version: 1.0 Received: by 10.210.35.17 with SMTP id i17mr3334059ebi.165.1235385613216; Mon, 23 Feb 2009 02:40:13 -0800 (PST) Date: Mon, 23 Feb 2009 10:40:13 +0000 Message-ID: Subject: Escaping special characters From: George H To: derby-user@db.apache.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Hi I'm a bit new to derby and I got stuck with escaping special characters like \n and \r. I'm constructing SQL insert statements in my java program and placing text inside which contain EOLs. They are not being escaped or something. I'm familiar with MySQL in that it converts all \n to \\n, this does not seem to work with derby, what does? -- George H george.dma@gmail.com