full text search in Arabic Langauge

[jone]

Hello there, I'm trying to use the full text search feature in SQL server 2000, when I search in arabic language I got a message telling that I'm searching for an ignored word the errore message I receive is:

--------------------
ODBC Error Code = 37000 (Syntax error or access violation)


[Microsoft][ODBC SQL Server Driver][SQL Server]A clause of the query contained only ignored words.
--------------------

I have tried to configure the SQL server settings, I added the following code in the functions:
--------------------------
exec sp_configure 'show advanced options', '1'
reconfigure

exec sp_configure 'default full-text language', '0'
reconfigure
exec sp_configure

reconfigure with override
--------------------------

But this didn't solve the Arabic language problem!

Please Advice

Regards

Jone

[Jeff Putnam]

SQL server has a list of 'noise' words which aren't indexed.. sounds like you're trying to search on them. Look in the Microsoft SQL ServerMSSQLFTDATASQLServerConfig folder for a list of these words.. you can change them, but you need to stop the search service first, and repopulate your catalogs when you're done.

Additionally, MS has identified a problem which is solved with SP1. Doesn't sound exactly like your problem, but if my above solution doesn't work, you might install the service pack.

------------
jone at 6/25/01 7:12:29 AM

Hello there, I'm trying to use the full text search feature in SQL server 2000, when I search in arabic language I got a message telling that I'm searching for an ignored word the errore message I receive is:

--------------------
ODBC Error Code = 37000 (Syntax error or access violation)


[Microsoft][ODBC SQL Server Driver][SQL Server]A clause of the query contained only ignored words.
--------------------

I have tried to configure the SQL server settings, I added the following code in the functions:
--------------------------
exec sp_configure 'show advanced options', '1'
reconfigure

exec sp_configure 'default full-text language', '0'
reconfigure
exec sp_configure

reconfigure with override
--------------------------

But this didn't solve the Arabic language problem!

Please Advice

Regards

Jone