Full-text queries


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Full-text queries

  1. #1
    Alexandre Kazuo Guest

    Full-text queries


    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.

  2. #2
    binod Guest

    Re: Full-text queries


    "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"


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center