Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-06 : 09:14:52
|
| Qadeer writes "Hi,I m using FullText Search in SQL Server2000 Enterprise Server. When I use Contains of FreeText commands with english query its working fine. But when I use 'ARABIC' word in query it returns an error Msg 7619 : level 16 'Query contains ingnore words'. If any body has solution plz. reply me also on my email address:qadeer92@hotmail.com." |
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2002-05-06 : 13:19:20
|
I'm way out of my depth, here, not speaking a word of Arabic...How is the Arabic being stored? I've just tried this with some sentences cut from the BBC Arabic News pages and pasted into an nvarchar column, and it did seem to work -- although Query Analyser won't display the result well since it hasn't a clue about bidi.However, the Full-Text indexer doesn't appear to have an Arabic setting, so unless the index is set to use Neutral in the Language for Word Breaker setting, it won't index any of the Arabic, and complains if you try using it in CONTAINS.Hope this helps a bit, at least.  |
 |
|
|
|
|
|
FullText Search in Arabic Language