Re: Oracle Text Problem with special characters

From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Tue, 3 Feb 2004 11:52:51 +0100
Message-ID: <bvnuo3$tl9gj$1@ID-152732.news.uni-berlin.de>

"Peter Gervais" <pgervais_at_mtg.de> schrieb im Newsbeitrag news:bvnq85$1tee$1_at_ulysses.news.tiscali.de...
> Hi everybody,
>
> we've a problem setting up our oracle Text index.
>
> If I'm looking for
>
> SELECT account_id
> FROM account
> WHERE CONTAINS( index_column1, '( %\&% ) ')>0
>
> I get all records from table account.
> What do I have to do to get only the records
> containg and '&' ?
> Any Idea
>
> thanks
> Peter
>

Hi.

"&" = Chr(38)

So what about
WHERE CONTAINS( index_column1, '( %'||Chr(38)||'% ) ')>0

hth, Jan Received on Tue Feb 03 2004 - 04:52:51 CST