Full-text queries

[Alexandre Kazuo]

I create a full-text catalog and run a query ("select * from products where
contains( product_name , 'café')"), but it not returned the rows containing
the word "cafe". What I have to do in order to the query returns the rows
containing the words "cafe", "café" and so on, using that same statement.
Is that possible?
Thanks.

[binod]

"Alexandre Kazuo" <a_kazuo@yahoo.com> wrote:
>
>I create a full-text catalog and run a query ("select * from products where
>contains( product_name , 'café')"), but it not returned the rows containing
>the word "cafe". What I have to do in order to the query returns the rows
>containing the words "cafe", "café" and so on, using that same statement.
>Is that possible?
>Thanks.

i guess the query should be like this .......prior to this i guess u have
defined the index properly for the column on which you will perform the search.

you have to start ctxctl (ctxsrv)
then start like
start 1 ddl dml query
start 1 query

then select * from cts_all_servers;
you should see that ur server is running
like drsrv_42736 something like this

this mightalso be necessary like in the init.ora file [text_enable = true]
or alter session set text_enable = true; will also do
then run the query stated below [i hope this solves ur priblem]
("select * from products where
>contains( product_name , 'café') > 0"