FTS Dutch operating system

I am getting an error running a full-text search against a database created
on a dutch operating system. The same query on the english-created database
does not produce an error.
System.Data.SqlClient.SqlException: Search on full-text catalog
'ImageCatalog003' for database ID 6, table or indexed view ID 1733581214 with
search condition 'ISABOUT ("pa" weight (.2))' failed with unknown result
(0x80020005).
Any Ideas?
Thanks.
Scott Taylor
"ScottTaylor-PAS" <ScottTaylor-PAS@.discussions.microsoft.com> wrote in
message news:BB50FCF3-0107-490A-8E54-0245FEC24D99@.microsoft.com...
>I am getting an error running a full-text search against a database created
> on a dutch operating system. The same query on the english-created
> database
> does not produce an error.
> System.Data.SqlClient.SqlException: Search on full-text catalog
> 'ImageCatalog003' for database ID 6, table or indexed view ID 1733581214
> with
> search condition 'ISABOUT ("pa" weight (.2))' failed with unknown result
> (0x80020005).
> Any Ideas?
> Thanks.
> Scott Taylor
|||This works for me on a SQL 2000 server and SQL 2005.
Are you sure you are indexing in Dutch? Also do you have problems with other
words?
"ScottTaylor-PAS" <ScottTaylor-PAS@.discussions.microsoft.com> wrote in
message news:BB50FCF3-0107-490A-8E54-0245FEC24D99@.microsoft.com...
>I am getting an error running a full-text search against a database created
> on a dutch operating system. The same query on the english-created
> database
> does not produce an error.
> System.Data.SqlClient.SqlException: Search on full-text catalog
> 'ImageCatalog003' for database ID 6, table or indexed view ID 1733581214
> with
> search condition 'ISABOUT ("pa" weight (.2))' failed with unknown result
> (0x80020005).
> Any Ideas?
> Thanks.
> Scott Taylor
|||Did you try it on a Dutch OS?
Any word I put in gives the same error.
I changed this line:
INNER Join CONTAINSTABLE( IMOC_003_Images ,[Image], 'ISABOUT ("test" weight
(.2))' ) as k
to this:
INNER Join CONTAINSTABLE( IMOC_003_Images ,[Image], 'ISABOUT (test:0.2)' )
as k
And now it works...but I don't know why.
Thanks for the reply,
Scott
"Hilary Cotter" wrote:

> This works for me on a SQL 2000 server and SQL 2005.
> Are you sure you are indexing in Dutch? Also do you have problems with other
> words?
>