full text search and verbs forms

Hi,
I'm running win 2003 and sql 2000 sp3a in spanish.
When I search in a full text query for a verb (using contains and not an
inflectional search) the result include the correct verb form but also
the various forms of that verb . For example if I search "comprar" the
results include "comprar".
I have the same problem if I search for a phrase containing verbs.
Is there a way to solve this problem?
Thanks in advance,
Robert.
Robert,
Could you post the actual CONTAINS query you are using? Specifically, are
you using a trailing asterisk "*" wildcard in your query?
Also, you should know that SQL 2000 FTS is accent insensitive regardless of
the database or table collation.
Regards,
John
"Robert" <rbroggi@.seciu.edu.uy> wrote in message
news:40A0FFDA.1090404@.seciu.edu.uy...
> Hi,
> I'm running win 2003 and sql 2000 sp3a in spanish.
> When I search in a full text query for a verb (using contains and not an
> inflectional search) the result include the correct verb form but also
> the various forms of that verb . For example if I search "comprar" the
> results include "comprar".
> I have the same problem if I search for a phrase containing verbs.
> Is there a way to solve this problem?
> Thanks in advance,
> Robert.
>
|||Hi John,
The query is: SELECT * FROM Textos WHERE CONTAINS(Texto,'"comprar
proximamente"')
The result include results like "comprar proximamente".
What do you mean by "SQL 2000 FTS is accent insensitive" ? I thought
that the full text engine was accent sensitive. For example if you
search "debera" will not be the same as "deberia". Is this correct?
Thanks for the help,
Robert.
John Kane wrote:
> Robert,
> Could you post the actual CONTAINS query you are using? Specifically, are
> you using a trailing asterisk "*" wildcard in your query?
> Also, you should know that SQL 2000 FTS is accent insensitive regardless of
> the database or table collation.
> Regards,
> John
>
> "Robert" <rbroggi@.seciu.edu.uy> wrote in message
> news:40A0FFDA.1090404@.seciu.edu.uy...
>
>