Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (athena.apache.org: domain of david.vancouvering@gmail.com
 designates 209.85.198.188 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:sender:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth;
        b=LrLvg1SD0q3mJcdU0YZQZbNBGUaBFmMXUtw+EDky1dS6OAmdMIWDwOuGUcqktP/8UZg9ygBm5pnEKbmK0dqImfNDh4n+eyT6gUq2KvdZk24r2DmhecbQJPSy1Tds+NFVi1aJJidAQqykXBbbs3C2QOqGjdZGbltiVRfuruvuEjY=
Message-ID: <56a83cd00708061146h5e3032b5j84eb1d010dd0c58d@mail.gmail.com>
Date: Mon, 6 Aug 2007 11:46:41 -0700
From: "David Van Couvering" <david@vancouvering.com>
Sender: david.vancouvering@gmail.com
To: "Derby Discussion" <derby-user@db.apache.org>
Subject: Re: DatabaseMetaData.searchStringEscape
In-Reply-To: <13054.149.qm@web31809.mail.mud.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <13054.149.qm@web31809.mail.mud.yahoo.com>

Yes, you're right, identifierQuoteString doesn't make sense in this
case.  I thought you were trying to quote the entire identifier.

I don't have an answer for you though, sorry!

David

On 8/4/07, Geoff hendrey <geoff_hendrey@yahoo.com> wrote:
> On the advice I got back from my last email, I tried to use getIdentfierQuoteString (which returns ").
>
>
> So I tried escaping the undescore like this:
> m.getColumns(null, null, tableName,  "%\"_\"XXX"); //find columns ending in _XXX
>
> but that doesn't work, nor does is really seem to make any sense. I really need the searchEscapeString. Without it, how can anyone use getColumns? It's *very* common for table names to have an underscore, but unless I can escape the underscore, it will be treated as a wildcard for any single character.
>
> I must be missing something.
>
> -geoff
>
>
>