sql server full text search: Are you looking for an Arabic word breaker? Your header seems to indicate
you are from the Middle East. If so have a look at this -

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_arabicsupport.asp
(this covers how to configure SQL FTS for Arabic - but uses the neutral word
breaker).

or this

http://www.microsoft.com/middleeast/arabicdev/beta/search/

Which is the Arabic word breaker.

If you simply want to search in another language all you do is configure
your column for the language of your choice (sp_fulltext_column) like this

exec sp_fulltext_column 'TableName', 'ColumnName', 'add', 1033

You might want to review this which talks about how to use the Wizard for
this:

http://www.indexserverfaq.com/SQLFTIWizard.htm

If you are looking at using at developing a new word breaker you might want
to review this

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/indexsrv/html/wbrscenario_4ckl.asp?frame=true

If you are looking for some of the new language resources options in SQL
2005 you might want to check this out.

http://www.pinpub.com/ME2/Audiences/dirmod.asp?sid=&nm=&type=Publishing&mod=Publications%3A%3AArticle&mid=8F3A7027421841978F18BE895F87F791&AudID=3A23D70D325A41A9AC644714EED86750&tier=4&id=9B590BE10DC44958AFB7F00F2BD43B5E

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

Leila,
What language are you looking to learn about customizing FT Indexing and FT
Search? Could you post the full output of the below SQL code, as this will
provide info on your current environment and perhaps the language you are
interested in is already supported.


use <your_database_name_here>
go
SELECT @@language
SELECT @@version
-- an advance option for sp_configure...
sp_configure 'default full-text language'
EXEC sp_help_fulltext_catalogs
EXEC sp_help_fulltext_tables
EXEC sp_help_fulltext_columns
EXEC sp_help <your_FT-enable_table_name_here>
go

I have worked in the past with someone from Greece, who implemented a custom
wordbreaker and stemmer for the Greek language (a non-trivial effort), and
helped him incorporate the Greek language (a non-supported SQL Server 2000
FTS language). What language do you want to add to SQL Server 2000 FT
Indexing & Search? Have you already developed your own language-specific
word breaker and stemmer?

Thanks,
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/


[quoted text, click to view]

Thanks for the great links!
Yes, arabic is the language which I'd like to enhance FTS for.




[quoted text, click to view]
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/htm
l/sql_arabicsupport.asp
[quoted text, click to view]
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/indexsrv/ht
ml/wbrscenario_4ckl.asp?frame=true
[quoted text, click to view]
http://www.pinpub.com/ME2/Audiences/dirmod.asp?sid=&nm=&type=Publishing&mod=
Publications%3A%3AArticle&mid=8F3A7027421841978F18BE895F87F791&AudID=3A23D70
D325A41A9AC644714EED86750&tier=4&id=9B590BE10DC44958AFB7F00F2BD43B5E
[quoted text, click to view]

Hi,
I need an article to learn customization of FTS for other languages.
Thanks in advance,
Leila