You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by Geoff hendrey <ge...@yahoo.com> on 2007/08/03 16:46:44 UTC

DatabaseMetaData.getSearchStringEscape() returns ""

I need to call DatabaseMetaData.searchStringEscape to determine the escape sequence, but it just returns "".  I cneed call DatabasMetaData.getColumns on a table whose name contains an underscore., which is why I need the escape string,  Ssince underscore is a reserved search character.

If there is another way to escape underscore, please let me know.

-geoff

Re: DatabaseMetaData.getSearchStringEscape() returns ""

Posted by David Van Couvering <da...@vancouvering.com>.

You might try getIdentifierQuoteString()

David

On 8/3/07, Geoff hendrey <ge...@yahoo.com> wrote:
> I need to call DatabaseMetaData.searchStringEscape to determine the escape sequence, but it just returns "".  I cneed call DatabasMetaData.getColumns on a table whose name contains an underscore., which is why I need the escape string,  Ssince underscore is a reserved search character.
>
> If there is another way to escape underscore, please let me know.
>
> -geoff
>
>
>