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/sq
l_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/w
brscenario_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=Publ
ications%3A%3AArticle&mid=8F3A7027421841978F18BE895F87F791&AudID=3A23D70D325A41A
9AC644714EED86750&tier=4&id=9B590BE10DC44958AFB7F00F2BD43B5E

Signature
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
> Hi,
> I need an article to learn customization of FTS for other languages.
> Thanks in advance,
> Leila
Leila - 18 Jul 2005 06:55 GMT
Thanks for the great links!
Yes, arabic is the language which I'd like to enhance FTS for.
> 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/htm
l/sql_arabicsupport.asp
> (this covers how to configure SQL FTS for Arabic - but uses the neutral word
> breaker).
[quoted text clipped - 17 lines]
> 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/ht
ml/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=3A23D70
D325A41A9AC644714EED86750&tier=4&id=9B590BE10DC44958AFB7F00F2BD43B5E
> --
> Hilary Cotter
[quoted text clipped - 8 lines]
> > Thanks in advance,
> > Leila
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

Signature
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
> Hi,
> I need an article to learn customization of FTS for other languages.
> Thanks in advance,
> Leila